I need to create a vacation spreadsheet and I need major assistance. Our employees vacation is by anniversary date and I would like the vacation to reset when each anniversary date rolls around automatically.

I have the employee names and DOH. I need to keep track of dates taken and for what, whether vacation, personal or Sick leave, bereavement, etc.

Below are the variables:

After 1 year the employee earns 5 days. Zero vacation from DOH until after first year.
Year 2-4 employee earns 10 days
Year 5 and after employee earns 15 days

At day 61 each employee earns 3 personal days and 3 sick days.

All must be taken within year earned or they loose them.

If anyone can help me I would greatly appreciate it.