Excel thinks 1900 was a leap year???

C

CR

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!
 
B

Bob Phillips

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)
 
T

Tom Ogilvy

Lotus 1-2-3 incorrectly treated 1900 as a leap year, so Excel has maintained
that error for compatibility reasons from its earliest verions - at least
that is the story that is told.

The work around would be to recognize that and adjust for it.
 
C

CR

Even though this is off-topic a little, but does anybody know if
OpenOffice's spreadsheet program has the same problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top