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

Sharing Access MDB or Accdb with client using older or newer version of Office 1
Outlook Backup issues 0
Using project as a resource tracker 0
How to bulk add section breaks after a particular combination of letters/numbers 0
Dates before 1900 2
Dates before 1900 and Year function 1
Incorrect Date function 7
Calculate elapsed time excluding specific timeframe 10

Top