On Sat, 11 Jun 2005 19:03:40 -0700, "Peo Sjoblom" wrote:

Oops! Change the DATE part to

DATE(5,6,5) and DATE(5,6,11)

The OP did not specify the century; but I should point out that your formula
gives a date of 1905-June-05 on my machine. And entering his posted dates into
my worksheet would give a year of 2005.

The DATE worksheet function:

If year is between 0 (zero) (4 for the 1904 date system) and 1899 (inclusive),
Excel adds that value to 1900 to calculate the year. For example, DATE(108,1,2)
returns January 2, 2008 (1900+108).



--ron