Good day,

I am trying to determine if Employee's are in a 5th anniversary year of there tenure. For example, employees's that started with the company on Aug 8, 2001; are in there anniversary year for there 5th year, so there vacation time will increase. I understand how to get Length of Service but cannot figure out this part. I was also thinking of trying to determine the End of Year date from sDate and maybe figure out from here but not sure.
Any help would be great.

Dim sDate as Date
sDate = Sheets("Main").Cells(5, 4)
Dim LOS As Integer
LOS = (Year(Now) - Year(sDate)) * 12 + Month(Now) - Month(sDate)

Chris