Our vacation policy is:

1-4 years = 10 days (80 hours/year, 1 Day/ 22 Days )

5 - 10 years = 15 days (120 hours/year, 1.5 Days/ 22 Days )

10 years = 20 days (160 hours/year, 2 Days/ 22 Days)

So far I have the following information set up:

A2 Name

B2 Hire Date

C2 TODAY ()

D2 =(C2-B2) (calculates the number of days since the employee was hired)

E3 I would like this to show the number of hours each employee has available to date.

I would greatly appreciate any help.

Thanks