View Single Post
  #3   Report Post  
Nick Hodge
 
Posts: n/a
Default

Dick

From Help in XL2003

Earliest date allowed for calculation
January 1, 1900 (January 1, 1904, if 1904 date system is used)

Latest date allowed for calculation
December 31, 9999

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"DickG" wrote in message
...
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?