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" wrote in message
...
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