View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pebbles pebbles is offline
external usenet poster
 
Posts: 9
Default next anniversary date

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.