Forum Discussion
How to sort data by date format
Hi - I'm using PC/Windows 10, and Excel version 2018 My excel data looks like this. I have 1500 rows. Date of hire Gender Race/Ethnicity Level Promotion Date new level term date type of...
Emma_Sabin You need to convert the text date to an Excel date that can be sorted. (They count the number of days from about 1 jan 1900 and can thus be sorted correctly).
In the example, it is possible to identify the format as M/D/Y but as mentioned in another reply, that is not always the case.
The attached file converts quite a few date formats from text to date.
When ambiguous, it returns multiple alternatives in column B.
For your need, column O should come handy.
Insert an extra column to calculate the Excel date and then use it for sorting your data.