| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Leap year indicator
"Peo Sjoblom" wrote in message
... "Robert" wrote in message ... =IF(((YEAR(D2)/4)-(INT(YEAR(D2)/4)))0,1,0) But that's the opposite to what you posted 21 Mar 2004 = 1 21 Mar 2003 = 0 And even having corrected that, the formula is wrong. 1600 and 2000 were leap years, but 1700, 1800, and 1900 weren't and 2100 won't be. -- David Biddulph |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 1900 not a leap year | Excel Worksheet Functions | |||
| How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
| Excel leap year question | New Users to Excel | |||
| DOnt calculate leap year | Excel Worksheet Functions | |||
| leap year question | Excel Discussion (Misc queries) | |||
Threaded Mode
