Calculating Dates

  • Thread starter Thread starter Gina1737
  • Start date Start date
G

Gina1737

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!
 
You can use the DATEDIF function as described in Chip Pearson's site
here:

http://www.cpearson.com/excel/datedif.aspx

to return the difference between two dates. The difference can be in
years, months or days, as Chip explains.

Then you could have a small table showing your steps in vacation
accrued, and use a VLOOKUP function to access the appropriate amount.

Hope this helps.

Pete
 
Back
Top