I don't know your layout, but Excel knows exactly which years are leap years, so probably you don't have to do anything special.

--
Kind regards,

Niek Otten

"Mike" wrote in message ...
I am creating an attendance chart. Using ex. A1= January 1,2006 and each
cell going forward is A2=A1+1,A3=A2+1 etc... When it comes to March 1st, it
is derived from Feb. 28th. I need to leave a blank cell between the two
dates, that will only be calculated during leap year, so as not to throw off
the calander.