Hi

Here's a "next birthday" formula with birth date in cell A1. Pretty long,
remove all line breaks that the posting may create:

=DATE(YEAR(TODAY())+((MONTH(A1)<MONTH(TODAY()))+(M ONTH(A1)=MONTH(TODAY()))*(
DAY(A1)<DAY(TODAY()))),MONTH(A1),DAY(A1))

--
HTH. Best wishes Harald
Followup to newsgroup only please

"scrabtree23" skrev i melding
...
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???