Holiday accrual change each year.

[DMY852]

Help,

Can someone help me to be able to change the holiday accrual if it changes after a certain length of time without affecting the balance from previous years.

I think the file is pretty self explanatory.

Thanks in advance

[tim201110]

=VLOOKUP(DATEDIF(B2,C2,"y"),{0,2;0.84,1.17},2)

[Phuocam]

Try:

=ROUND(MIN(DATEDIF(B2,C2,"m"),24)*0.84+MAX(0,DATEDIF(B2,C2,"m")-24)*1.17,2)

[DMY852]

Thanks so much for the options but as a novice I cannot get either to work.

[JeteMc]

Try pasting Phuocam's formula into cell F5 then press Enter. It yields a value of 75.15 which seems to be a reasonable value.
Let us know if you have any questions.

[DMY852]

I'm sorry but thats not what i need.
I need to be able to change individually the staffs yearly vacation accrued days( say....10 days year 1 and 2 and 12 days year 3).Without adjusting years 1 and 2 to the new accrued days.
Much appreciated

[JeteMc]

I made a mistake in my previous answer. Phuocam's formula when copied down to cell F5 would read:

Please Login or Register  to view this content.

It yields a value of 50.58 as of today, which is 20.16 days (0.84/mo.) for the first 2 years and 30.42 days (1.17/mo.) for the 2 years and 2 months since October 2015. If that isn't the expect result please let us know what result you would expect and why.
Let us know if you have any questions.