Originally Posted by Roger Govier[_3_]

Hi

I think we need more information.
Clearly the rate of vacation days, relates to having been employed for an
ever increasing time period.
I would set out a table in A1:B4 as follows

Months | Days Vacation
0 | 6.25
24 | 9.38
48 | 12.5
60 | 15.63

Change the values in column A to match the time frames you use.
Then with Date in F2
=VLOOKUP(DATEDIF(F2,TODAY(),"m"),$A$1:$B$4,2)

--
Regards
Roger Govier

"Lori1218" wrote in message
...

I am having a problem creating a formula . what I am trying to do is
working off a changing date to see what accrual rate is for vacation
time. My todays date is in C2. Employees accrue at different rates per
so many years
Vac Accrual 6.25(F1) 9.38(G1) 12.5(H1) 15.63(I1)
Hire Date 6/1/199(F2) 7/8/1997(G2) 7/29/2003 (H2) 7/16/2013 (I2)


Today is 8/30/2008
=IF(F2=MONTH(C2),"6.25",IF(G2=MONTH(C2),"9.38",I F(H2=MONTH(C2),"12.5",15.63)))

I tried this formula and I am way off. I have never done a nested if
function. Could some please help.




--
Lori1218