How To Sort Dates In Ascending Order in Excel

[@mariaboghean2759]

Very useful info! Thanks for sharing!

[@cogwheelLearning]

Thanks ❤️

[@RocketMyDog1]

Sorts by month and day, but not by year.

[@cogwheelLearning]

Hmm, that doesn't sound right. Perhaps there's something wrong with the data?

[@schalkferreira8008]

My dates are short dates but when I sort it does not sort from lowest to highest it is resorting it but not in chronological order? What can be wrong?

[@cogwheelLearning]

Have you checked if they are formatted as dates? The format could be General and it might mess with the sorting

[@cogwheelLearning]

🚨 Checkout this playlist for more Microsoft Excel tips:
ruclips.net/p/PLQHFVtY7qRaufg0mmtiP3NWvHJCo0WT07

[@ChallengerRhino]

American dates are so frustrating when you get data from the US and you need to work with it in Europe and Excel thinks, for example, that 01/01/2021 is a valid date, but 24/01/2021 isn't.

[@cogwheelLearning]

Excel is really weird with dates sometimes 😂