Forum Discussion
Sorting Dates which include some before 1900
I am sorting Ancestry information that includes Birth dates. The dates sort correctly if they are newer than 1900. The dates that are older than 1900 aren't sorted. Marriage and Death dates have the ...
Excel does not support dates before 1900, so it treats them as text.
Your best bet might be to create three extra columns with year, month and day.
You can use the ISTEXT function to distinguish between dates before and after 1900.
For dates before 1900, i.e. text values, you have to split the text into its parts.
For dates after 1900 you can use the YEAR, MONTH and DAY functions.
- Thanks for your reply. I found the solution. Click right/format cell/ date.
I changed the date format. Finally resolved.
