calculate with dates before 1-1-1900

[jan wan]

how can i calculate with dates before 1-1-1900? i also can't change the
property of the cell when using dates before 1-1-1900.

 

[Dave R.]

Here's something that may help.

http://www.j-walk.com/ss/excel/usertips/tip028.htm

 

[Myrna Larson]

Excel's "true" dates start with Jan 1, 1900. It doesn't natively support
earlier dates. To use them requires that they be entered as text and
manipulated with VBA routines.

Depending on your need for these dates, the database program Access can handle
these dates and may be a better choice for you it you have it.

 

[jan wan]

Works perfectly. thank you.

Here's something that may help.

http://www.j-walk.com/ss/excel/usertips/tip028.htm