sorting dates

New Contributor

How do I sort dates such as 5/2/2019 and 5/2/2020 when the only sorting field is A to Z and Z to A?


1 Reply


First you need to convert texts which represent dates into actual dates. In Excel in background date are integer numbers. You may select column with such texts, on ribbon Data->Text to Columns and on third step of the wizard select Date and MDY (or DMY, I don't know in your sample it's 2nd of May or 5th of Feb).


With that sorting will show "From oldest to newest" or like.