Formula for Vacation Accrual Days Based on Anniversary Date

Hello,

I am creating a vacation accrual spreadsheet and I need assistance in the cells highlighted in green. The vacation accrual should reset itself automatically when the employee's anniversary date rolls around. The frequency of the accrual should be daily.

I have 2 different tabs. One for hourly employees and the other for salary. Both should work the same, with the exception of the amount of vacation time alotted hr. vs. salary.

I have the spreadsheet attached. I would like to only manually populate the cells highlighted in yellow and have the green ones automatically calculate.

Can you please help me to create the cells highlighted in green?

Thank you,