Formula that adds personal time on anniversary date but moves excess to sick time

Formula that adds personal time on anniversary date but moves excess to sick time



In my office, each year on an employee's anniversary date, they accrue 22.5 hours of personal time. If they didn't use all of their personal time during the previous year, it moves to sick time so they cannot have anything above 22.5 hours of personal time. Sick time is unlimited. I need this to automatically happen each year.

Any help is greatly appreciated.

Thank you

Example:

Employee: Doe,John
Sick time: 122.5
Personal : 14.5
Anniversary Date: 01/14/2009