Google Sheets - How to Sort Dates into Chronological Order [Updated]
ฝัง
- เผยแพร่เมื่อ 26 ส.ค. 2024
- Learn how to sort dates into chronological order using two different methods. First, we'll use Data Validation, and then we will use the ISDATE function.
Choose which one works best for your spreadsheet, and your dates will sort chronologically.
This video came about because a previous video about sorting dates got a comment from @DumbSathanass pointing out that I never actually sorted the dates in the video! Keep the comments coming.
Learn more from Prolific Oaktree:
🌳 Next Video - Google Sheets - Prevent Duplicate Entries - • Google Sheets - Preven...
🌳 Related Playlist - Google Apps | Full Tutorials - bit.ly/google-...
#googlesheets #sort #ISDATE
Straight to the point❤❤❤ good vid
Thank you so much sir in this 6 minutes video you have solved my all doubts which I was finding in TH-cam since last 3-4 days but now I got your vid 👍
Love from India ❤️
Awesome! I get great viewers from India for sure!
Thank you. While I was awar of how to sort columns and validate, I didnt know you double could click on the lower right of the auto-complete to fill to the bottom (doh).
Guess that is why I watch those videos :D
It saves a ton of time. Now it's painful to watch people use a spreadsheet when they don't know the trick.
Very helpful! Thank you!
You're welcome!
Can you synchronize dates from your Apple iPhone- I see the “desktop” includes “date” “sort “ where is that option on the iPhone?
Thank you so much. This is very helpful
Thank you. The weird thing is I puit these colored bars in certain rows, in order to divide weeks. Google sheets did something hillarious when I flipped the table, (which worked perfectly by the way). It collected up all of the bars, and just piled them up at the bottom of the spreadsheet. I guess it didn't know what to do with them lol. I just added them back in. Thank you again!
Whoa dude.
Thank you!
How do you do this one your Apple mobile?
Would it also work for this
timeline settings
disney animated canon
"Fantasia: Rite of Spring 65,000 BCE
"
"Fantasia 2000: Pomp and Circumstance 1800 BCE
Firebird Suite 1590 BCE
"
Fantasia: The Pastoral Symphony) 1277 BCE
brother bear 10,000 bc
Atlantis The Lost Empire 7000 BC
The Lion King 1178 bce
Hercules 1179 bce
Moana 984 bce
The Sword In The Stone 400s
Mulan 500s
fantasia the sources apprentice 740
fantasia night on bald moutian 1025
The Black Cauldron Dark Ages
Aladdin 800s
Robin Hood 1194
Sleeping Beauty 1300s
The Hunchback Of Notre Dame 1482
The Emperor's New Groove -1500
Snow White And The Seven Dwarfs early 1500s
Pocahontas 1607
Fun and Fancy Free: Mickey and the Beanstal 1734
Beauty & The Beast 1770s
The Adventures of Ichabod 1790
Melody Time: The Legend of Johnny Appleseed 1795
Tangled 1820
Frozen 1820
Frozen 2 1823
Melody Time: Pecos Bill 1858
Alice In Wonderland 1862
Fantasia 2000 the steadfast tin soldier
Cinderella mid 1860s
Tarzan mid 1882
Pinocchio 1883
Make Mine Music: The Martins and The Coys 1885
Make Mine Music: The Whale Who Wanted to Sing at the Met 1886
make mine music casey at the bat 1888
make mine music johny fedora and alice bluebonnet 1889
melody time once upon a wintertime 1890
fantasia nutcraker 1892
Home On The Range mid 1875s
fantasia dance of the hours 1876
The Jungle Book 1893
The Little Mermaid mid 1890s
Basil The Great Mouse Detective 1897
Peter Pan 1900
Mr Toad 1906
Lady & The Tramp 1908
The Aristocats 1910
Atlantis The Lost Empire 1914
The Many Adventures Of Winnie The Pooh 1926
Winnie The Pooh 1926
fantasia 200 RHAPSODY BLUE 1932
make mine music Peter and the wolf 1936
"make mine music blue bayou 1936
"
Dumbo 1941
fun and fancy free bongo 1941
Saludos Amigos 1942
The Three Caballeros 1944
make mine music all the cats join in 1946
melody time little toot 1948
Bambi 1942
fantasia 2000 pines of rome 1924
101 Dalmatians 1961
Rescuers 1-2 1970s
The Fox & The Hound 1981
Oliver & Company 1988
"Fantasia 2000: The Carnival of the Animals 1999
"
Lilo & Stitch 2002
Chicken Little 2002
Meet The Robinsons 2007
Bolt 2008
Super Rhino 2008
Wreck-It Ralph 2012
Big Hero 6 2014
Zootopia 2016
Wreck-It Ralph 2 2018
Meet The Robinsons 2037
Treasure Planet 10000000000000000000...
Great video helped big time but the dates didn't stay with the item associated with the dates. Smh
How to sort the entire row?
Select the entire range you want to sort before you sort it.
I want to organize the dates chronologically but in google sheets pivot, it is sorted by month alphabetically such as Apr, Aug. I want the google sheet pivot rows to be sorted as Jan, Feb, Mar etc. Please help! Thanks!
Maybe something like add a column to the source data using the MONTH function ran on the date column. This will return month numbers. Then, use this as a column in the pivot table and it should sort them in order.
When I click on Data Validation I get a completely different prompt which doesn't give me the options you got. Anyways what I'm looking is for ways to sort week numbers from last year and this year so it doesn't move this year's weeks into the front of week numbers 49-52 of last year
when need to click on sort range and advance range sorting options
I actually am looking for an easy way to change the month in a column of dates so I can update a dashboard. Right now in order to do that I have to manually click on each cell and change from June to July. It's tedious and I'm wondering if there's an easier way to do this.
Maybe break the date down with the MONTH, YEAR, and DAY functions then put it back together again adding one to the MONTH. See here for a bit more: sheetshelp.com/month/
Thank you.
You're welcome!
I know I've seen this done. Is there a way to just click on, say, where you have "Date" in the column and it sorts it for you?
Apply a filter to the data, then you can do this.
how do I sort by MM only when I have dates with different years?
Try adding a column with the MONTH function and sort by that.
Is there a way to sort or set "Comments" so they appear newest to oldest?
Not that I'm aware of. Would be nice though!
Thank you
You're welcome!
How do I change it to a British Date format?
Go to the Spreadsheet settings in the menu. Change your locale.
@@ProlificOaktree Done! Thank you!