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

Advertisements

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

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

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top