You just need to cater for it with 1900, adjust by 1.

--
HTH

Bob Phillips

(replace xxxx in email address with googlemail if mailing direct)

"CR" wrote in message
oups.com...
If I have a cell A1 with the formula:

=DATE(1900, 4, 15) == Easter Sunday in 1900

and then I try to calculate Ash Wednesday for 1900 in cell B1, which is
46 days before Easter:

=A1 - 46

Excel gives 2/29/1900 as the answer in B1. Great. Except 1900 was not
a leap year. Has anybody figured out a work around? I'm on Office2K
SP3.

Thanks!