karen_joy

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_ID

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)

 

4-5

12.5 days

 

5 - 9

15 days  (3 weeks)

 

9-10

18 days

 

10 - 19

20 days  (4 weeks)

 

 

Thank you.

Outcomes