Vacation Calculator

[Sarah]

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.

 

[Gary Brown]

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.