Dates before 1900

[Cordlina]

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?

 

[Pete_UK]

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

http://spreadsheetpage.com/index.php/tip/working_with_pre_1900_dates/

Hope this helps.

Pete

 

[מיכ×ל (מיקי) ×בידן]

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