Hi. I have an employee that was hired on 4-1-2003.
I use =DATEDIF(E64,TODAY(),"y") to determin that he has worked 6 yrs. When
he reaches his anniversay date, his vacation time will go from 80 hrs to 120
hrs. I use VLookup to determine the vacation time. This all works okay.

The problem is that on January 1, my business posts a list of vacation
allowances for the year. The list shows how much vacation time the employee
gets, regardless of when the anniversay date is. So my above employee will
show that he has 120 hrs of vacation time on January 1. This is only a
problem when the employee is in a year where vacation time changes from one
level to the next.
Vacation time changes when the employee goes from year 6 to 7, year 13 to
14, year 19 to 20 and year 24 to 25. Can anyone help make this work during
those years?

Thanks for any help.