next anniversary date

[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.

 

[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

 

[pebbles]

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

 

[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.

 

[pebbles]

Thank you so much!! That's perfect!

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).

 

[David Biddulph]

You're welcome.
--
David Biddulph

Thank you so much!! That's perfect!