View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim Nealon Tim Nealon is offline
external usenet poster
 
Posts: 7
Default add 2 months and a variable number of days to a date

I am trying to calculate a health benefits schedule. I would like to know
the month an employee becomes eligible for health benefits. An employee is
eligible on the first day of the month following 2 months of employment.
For example, if an employee is hired anytime during the month of September,
he would be eligible for benefits on December 1. If he is hired in October,
he would not be eligible until January 1 of the next year.
My hire date is in MM/DD/YY format. Does anyone know how to calculate the
"eligible for benefits" date?
Thanks