I have my spreadsheet of employees set up to track days used (date from - date returned), then I have hire date and years of service based on the (today date). I have vacation hours for the year (to include the 2 day roll over) then vacation day remaining.
The rate for 80 hours is accrual at 1.53 hour a week. The rate 2.5 is for 120 hours.
80 hours is 0-2 years
120 hours is 3-5 years
160 hours 6 years and up

I need a formula that will change the accrual rate when the employee reaches one of the milestone anniversary. Thank you