Not clear why you are using 364 not 365, but assuming you want 365 for leap
years, try

=IF(TODAY()=M34,IF(MONTH(DATE(YEAR(TODAY()),2,29) )=2,365,364),0)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

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