LOL! I guess I am too tired today()

--
Regards,

Peo Sjoblom

(No private emails please)


"Ron Rosenfeld" wrote in message
...
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