Here's something that may help.

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



"jan wan" wrote in message
...
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.