On Sat, 8 Jan 2005 21:27:01 -0800, "DickG" <DickG@discussions.microsoft.com>
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?

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