# next anniversary date

P

#### pebbles

I want to calculate an employee's next anniversary date. If an employee was
hired earlier this year I need the date to reflect next year. Some
anniversary dates have already occured this year so changing the year of the
hire date to the current year won't work.

M

#### Mike H

hi,

I don't understand how adding 1 year to the hire date doesn't calculate the
anniversary so why not hire date in a1 and

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))

Mike

P

#### pebbles

If they were hired several years ago it only adds one year

P

#### pebbles

David,
This formula is close to what I need but it's showing '09 as the next
anniversary for dates that haven't passed yet this year, and '08 for dates
that have. Am I missing something? For instance, a person hired on 4/1/06,
their next anniversary will be in '09, a person hired on 08/12/99, their next
anniversary will be in '08.

P

#### pebbles

Thank you so much!! That's perfect!

David Biddulph said:
Yes, it was too late in the day when I was doing that.
Just change the > in the formula to < (or <=, depending on how you want to
treat anniversaries occurring today).

D

#### David Biddulph

You're welcome.
--
David Biddulph

pebbles said:
Thank you so much!! That's perfect!