View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gina1737 Gina1737 is offline
external usenet poster
 
Posts: 1
Default Calculating Dates

I need help in returning a pre designated number dependent upon the passing
of dates. For instance, I need to calculate when 13 months have passed since
hire date, the employee will receive X amount of vacation per month and when
48 months pass from hire date, then a different number should be returned,
and so on. We have 5 different steps that I would like to have returned
automatically dependant upon the current date. Any assistance will be
greatly appreciated. I am going crazy trying to find the answer. Thank you!