Entering dates in Excel 2002

[DickG]

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?

 

[Ron Rosenfeld]

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?

You would need to use a VBA routine for this (or write some complex
string-parsing formulas).

Excel by itself does not recognize dates prior to 1900.

What is your potential date range?
--ron

 

[Nick Hodge]

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
(e-mail address removed)

 

[Dave Peterson]

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

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