Dates pre 01/01/1900


X

xpnovice

Hi,

I can manipulate dates and times fine when they are post 01/01/1900, and I
know that this is the base date for Excel date numbering.

I had automatically assumed, but never needed to apply, that when I wanted
to calculate historical dates prior to 01/01/1900 that the values returned
would be a minus value, but still a valid number.

I now want to calculate values using dates prior to 01/01/1900 and find that
even if I format the cells to date and then enter a date, the values are
assigned as text, and therefore I am not able to do any calculations.

For example I cannot calculate the number of days between the dates
16/12/1770 and 26/3/1827.

Is there a way around this, or can dates only be manipulated if they are
post 01/01/1900?

Thanks
John
 
Ad

Advertisements

Ad

Advertisements


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

Top