Leap year indicator

[Robert]

Is there a function to indicate if the YEAR of a given date is a leap year.
eg. 21 Mar 2004 = 1
21 Mar 2003 = 0
Thank you

 

[Peo Sjoblom]

One way

=--(DAY(DATE(YEAR(A1),3,0))=29)

assuming the date starts in A1 copy down

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Robert]

=IF(((YEAR(D2)/4)-(INT(YEAR(D2)/4)))>0,1,0)

 

[Peo Sjoblom]

But that's the opposite to what you posted

21 Mar 2004 = 1
21 Mar 2003 = 0

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Robert]

Thanks Peo for pointing the mistake. In view of Article ID21436 in MS Help
and Support, I shall adopt yours.

 

[David Biddulph]

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.