Hi All,

I am trying to create a worksheet for vacation hours for my company. Essentially I want it to take the Hire date of the employee and calculate how many hours they will accrue in the current calendar year. Our vacation time accrues per pay period (26 pay periods in a calendar year). The breakdown of time earned is as follows:
Upon completion of 6 months of service the employee receives 40 hours of vacation. No vacation is accrued during that first six months. Following the 6 month anniversary date the employee will begin accruing additional vacation time each pay period. Then every January everyone is reset back to 0 and begins to accrue time again .

6-12 months - 40 hours
1 year - 5 years - 80 hours
5 years - 10 years - 120 hours
10 years or more - 160 hours

I appreciate any help you can provide. I am terrible with dates on excel.