Leap year indicator

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
--
Robert

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" <bobbell@discussions.microsoft.com> wrote in message
news:479A5889-259C-4DC1-AD0A-03F4307C127A@microsoft.com...
> 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
> --
> Robert

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

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

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" <bobbell@discussions.microsoft.com> wrote in message
news:D843B48C-A4CB-4E2A-A424-AC6C455A56E4@microsoft.com...
>
> =IF(((YEAR(D2)/4)-(INT(YEAR(D2)/4)))>0,1,0)
> --
> Robert
>
>
>

"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
news:uuiFREweGHA.5040@TK2MSFTNGP03.phx.gbl...

> "Robert" <bobbell@discussions.microsoft.com> wrote in message
> news:D843B48C-A4CB-4E2A-A424-AC6C455A56E4@microsoft.com...
>>
>> =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