Vacation Calculator

  • Thread starter Thread starter Sarah
  • Start date Start date
S

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I calculation vacation accrual? 1
Vacation Accruals Database 0
Vacation accrual based on years with rollover 1
Time Keeping Spreadsheet (Need not to Exceed Formula & subtracting 1
Vacation Tracking 1
Vacation Accrual formula 1
if statement = if number is between 1
Accured Vacation Formula 1

Back
Top