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!

Calculating Dates
 

You can use the DATEDIF function as described in Chip Pearson's site
he

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

On Jun 17, 12:20*am, Gina1737
wrote:
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!