Trying to figure out how to cap the amount of hours someone accrues for vacation based on company policy.
Let's say that an employee caps out at 37 days and earns 25 days per year at a rate of 2.1 days per week.
My formula that calculate the number of hours available is: =(MONTH(H$1)*G5)+(B2*8); H$1 is today's date, G5 is the weekly accrual rate in hours, and B2 is the number of days that the person is carrying over from last year.

Thoughts??