Forum Discussion
kepa1
Apr 22, 2020Copper Contributor
Sorting by date
I have an excel sheet of twelve columns, 700 rows, with number and text entries. The single Date column A is input as 1600/00/00. 1863/03/21, to 1996/04/00, 2020/04/08... etc. (yyyy/mm/dd format). S...
Riny_van_Eekelen
Apr 23, 2020Platinum Contributor
kepa1 Excel can't handle dates before the year 1900, so you will never be able to sort-oldest-to newest using the date format. In stead, your "Date" column should contain texts that look like a date in the format you described. Then you can sort based from A to Z or from Z to A. (See attached file).
You could also consider to split the dates by using text-to-columns and / as the delimiter. Make sure you import each columns as text to preserve the zero's in the months and days. Then you can do a multiple sort. First by year, then by month, then by day.