| 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! |
| 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)
Threaded Mode
