Working with dates in Excel older than 1900
Are there any workarounds for working with time and date data prior to January 1, 1900? Excel seems to just assign my values dates in 1900 rather than keeping them intact.
Solution 1:
Some ideas from exceluser.com:
- Enter them as text, in YYYY-MM-DD format. This should allow sorting to work as expected.
- Create or install a macro that converts dates before 1900 to a negative serial. (The site links one.)