As I read you question, you need to know how many year employer will have
worked not on 1 Jan but on 31 Dec
So it I will reach my 7th anniversary in mid-June then on Jan 1 the posted
notice should say I get 120 hours.
How about changing your formula to
=DATEDIF(E65,DATE(YEAR(TODAY()),12,31),"y")
The result will mean: by the end of this year employer will have been here X
years.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"RM270" wrote in message
...
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.