next anniversary date

  • Thread starter Thread starter pebbles
  • Start date Start 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.
 
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
 
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.
 
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).
Click to expand...
 
Back
Top