Dates before 1900
 

How does excel treat dates that are before 1900? Is there a way to
automatically format March 16, 1836 so excel recognises it as a value that
can be used in calculating number of days between dates as is done for post
1900 dates?

Dates before 1900
 

John Walkenback has a free add-in that you can download from he

http://spreadsheetpage.com/index.php...re_1900_dates/

Hope this helps.

Pete

On Dec 22, 1:01*pm, Cordlina
wrote:
How does excel treat dates that are before 1900? Is there a way to
automatically format March 16, 1836 so excel recognises it as a value that
can be used in calculating number of days between dates as is done for post
1900 dates?

Dates before 1900
 

Try to find some help in the hereunder links:
http://www.j-walk.com/ss/excel/usertips/tip028.htm
http://support.microsoft.com/kb/245104
*** Google will provide some more...
Micky


"Cordlina" wrote:

How does excel treat dates that are before 1900? Is there a way to
automatically format March 16, 1836 so excel recognises it as a value that
can be used in calculating number of days between dates as is done for post
1900 dates?