dates older than 1900

P

P Boric

how can I sort dates older tha 1900? In an ascendent sort, Excel order them
at the end, and it fails too calculating amount of days elapsed
 
P

P Boric

Thanks, they have an add-in, I downloaded it, and worked fine. now, I am able
to calculate the day of the week and other formulaes.
In order to sort a mixed list of dates, before and after 1900, I had to
separate the dates first in year, month and day, and then perform a complex
sort
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates before 1900 and Year function 1
Dates before 1900 2
Incorrect Date function 6
I can't get Excel to caluate dates in the 1800's. #VALUE! 1
Sorting pre-1900 dates 2
Dates prior to 1900 2
Time format 2
Calculating age when person born before 1900 1

Top