Leap year indicator

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