| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel thinks 1900 was a leap year???
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel thinks 1900 was a leap year???
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel thinks 1900 was a leap year???
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. -- Regards, Tom Ogilvy "CR" wrote: 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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel thinks 1900 was a leap year???
Even though this is off-topic a little, but does anybody know if
OpenOffice's spreadsheet program has the same problem? Tom Ogilvy wrote: 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. -- Regards, Tom Ogilvy "CR" wrote: 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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel thinks 1900 was a leap year???
http://www.openofficetips.com/blog/a...ime/index.html
search for leap year or 1900 and it indicates that OpenOffice has not inherited this behavior. I found another citation that confirmed this and stopped looking. -- Regards, Tom Ogilvy "CR" wrote: Even though this is off-topic a little, but does anybody know if OpenOffice's spreadsheet program has the same problem? Tom Ogilvy wrote: 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. -- Regards, Tom Ogilvy "CR" wrote: 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! |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel thinks 1900 was a leap year???
Excellent. Thanks Tom. OO is looking more and more appealing...
Tom Ogilvy wrote: http://www.openofficetips.com/blog/a...ime/index.html search for leap year or 1900 and it indicates that OpenOffice has not inherited this behavior. I found another citation that confirmed this and stopped looking. -- Regards, Tom Ogilvy "CR" wrote: Even though this is off-topic a little, but does anybody know if OpenOffice's spreadsheet program has the same problem? Tom Ogilvy wrote: 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. -- Regards, Tom Ogilvy "CR" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =YEAR(3/7/2007) in EXCEL, get the answer as 1900. Why? | Excel Worksheet Functions | |||
| Incorrect Excel date 1900 is not a leap year 1/1/1901 < 367 | Excel Discussion (Misc queries) | |||
| 1900 not a leap year | Excel Worksheet Functions | |||
| is 1900 a Leap Year? | Excel Discussion (Misc queries) | |||
| Excel leap year question | New Users to Excel | |||
![CR[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
