Advice & Help (Calculation) for making a Vacation Tracker

Discussion created by karen_joy on Dec 5, 2016
Latest reply on Dec 5, 2016 by karen_joy

Hello Guys,


I am planning to start my vacation tracker data base, but I don't know if I'm on the right track and How to calculate the vacation allowed days and remaining days


I have Employee Table with the following Fields



Employee Name

Date Hire

Vacation Allowed

Vacation Taken

Vacation Remaining


How can I calculate the annual vacation base on the below condition


Schedule: Regular full-time employee (40 hours per week)

Years of Service

*Maximum Annual Vacation Entitlement


1 - 4

10 days  (2 weeks)



12.5 days


5 - 9

15 days  (3 weeks)



18 days


10 - 19

20 days  (4 weeks)



Thank you.