Eligle Vacation Hours Based On Hire Date

I'm looking for a formula that will figure the amount vacation hours an employee is eligble for based on his/her hire date and going by the current days date. It would keep me from manually figuring an employee's vacation time that they are due every time their anniversary date rolls around.

Here are the parameters that my company uses in order to award vacation time:

1) After the 1st year of employment, full time employees get 40 hours.

2) After the 2nd year of employment, Full time employees get 80 hours.

3) After the 9th year of employment, full time employees get 120 hours.

4) After the 16th year of employment, full time employees get 160 hours

Originally Posted by daddylonglegs

Is it always zero for part-time employees? If so try this formula in E3 copied down

=IF(D3="F",LOOKUP(DATEDIF(C3,TODAY(),"y"),{0,1,2,9,16;0,40,80,120,160}),0)

Originally Posted by AZ-XL

d3 cell =
=VLOOKUP((TODAY()-C3)/365,{1,40;2,80;9,120;16,160},2,TRUE)*(D3="F")

then drag down

Thanks guys! Will let ya know how these work!

They both worked like a charm... Thank you!