John Walkenbach created an addin that allows you to work with dates before 1900.

You can find it he
http://j-walk.com/ss/excel/files/xdate.htm


DickG wrote:

Is it possible to enter and use dates prior to January 1,1900, in
calucaltaions in Excel 2002. Specifically trying to calculate the number of
days between two dates where one or both of the dates are prior to January 1,
1900. If so how?

--

Dave Peterson