Forum Discussion
Problems sorting by Date
Dansker I'll take your word for it that the dates are in fact real dates. But, just to be sure, you can check that by referencing a cell with a date with ISNUMBER(cell). It should return TRUE. If it returns FALSE you are dealing with texts looking like dates, despite the text-to-columns procedure you performed.
The dates in your list seem to be sorted in descending order (newest first).
With respect to Excel wanting to include the header row in the sort, note that you can have only one header row. You mention that the first row is a Title and the second is the Header. Insert an empty row between the Title and the Header and the sorting will correctly recognise the Header row and exclude it from the sort.
Dansker I'll take your word for it that the dates are in fact real dates. But, just to be sure, you can check that by referencing a cell with a date with ISNUMBER(cell). It should return TRUE. If it returns FALSE you are dealing with texts looking like dates, despite the text-to-columns procedure you performed.
The dates in your list seem to be sorted in descending order (newest first).
With respect to Excel wanting to include the header row in the sort, note that you can have only one header row. You mention that the first row is a Title and the second is the Header. Insert an empty row between the Title and the Header and the sorting will correctly recognise the Header row and exclude it from the sort.
Riny_van_Eekelen , thank you!
Actually, the issue was user error (me). The one year should have been 2037, not 1937.
I added the blank row and fixed the date and it worked perfectly.
Thank you again!