Thread: Leap Year Blues
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike
 
Posts: n/a
Default Leap Year Blues

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.