Have a column in the employee's record that calculates years of service.
=int( (now() - Hire Date) / 365)
use this value in a vlookup to your accrual schedule.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"Sarah" wrote:

I am attempting to calculate vacation time for employees based on years of
service. I do not know how to write the function to do so. I have an
accrual schedule to base this on.