Forum Discussion
dates sorting
I cant sort dates in my table from the oldest to the new. the data identified as a date, but when I choose sort, I don't see option to sort like a date.
How do you know you actually have dates, not their text representations? If such 'date' is in A1 and in any empty cell you try =ISTEXT(A1), is it return TRUE or FALSE?
SergeiBaklan its say true. but its still sorting unlike dates.
thank you!
If your texts are in column, you may convert them to dates by Data->Text to Columns selecting on third step of the wizard Date format and proper DMY (or what do you have) format.
The fact that you have a text representation of the date is the cause of the problem.
Excel stores valid dates as a number and only then will sorting give the correct result.
The numeric representation corresponding to the text version is given by
= DATEVALUE(dateText)
