Vacation Tracking for Employees

I am doing vacation tracking and employees get new vacation days on the day and month that they were hired EX 8/19. The year they were hired is not relevant information.

I have a column called Used vacation days that should reset to 0 when the anniversary hire date occurs, and stay at 0 after the current date passes and until the same day and month next year.


Currently using:
=IF(AND(DAY(A3)=DAY(TODAY()), MONTH(A3)=MONTH(TODAY())),0,B3)

Lets use the current date of 6/8 as an example.
If the date changes to 6/9, then the 6/8 value returns to 25 and only the 6/9 value becomes 0. I need a formula that will keep the vacation in effect at zero until the same date next year occurs.


start Date Eligible Vacation Balance Vacation -In Effect
8/19/1996 25 25
6/8/1998 25 0
6/9/1999 25 25