Thread: Leap Year
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
scrabtree23[_2_] scrabtree23[_2_] is offline
external usenet poster
 
Posts: 25
Default Leap Year

I have a formula that calculates an employee's anniversary
date. It looks like this:

=IF(TODAY()=M34,364,0)

Another formula takes the result of this cell and adds it
to the employee's current anniversary date.

However, I have not taken into account for a leap year???