Calculation of Vacation allowed

[karenjoy]

Hello guys & gals,

I want to get help to calculate the vacation allowed base on the condition below

Years of Service	Vacation Allowed
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)

 

Please find attached file that Im working.

 

Thank you so much in advance.

 

KJ

 

Vacation Tracker.fmp12

Edited December 5, 2016 by karenjoy

[doughemi]

Are years calculated from anniversary date or from some other date?

[karenjoy]

Yes, their vacation is base from their date of hire.

Thank you.

[doughemi]

Try this:

Vacation Tracker_dh1.fmp12

[bruceR]

Or this. Seems to me contracted vacation rates really belong in a separate table.

These are (over) simplified examples of course.

Vacation Tracker_bfr.fmp12

[karenjoy]

Thanks doughemi...

Thanks Bruce for the package...I really appreciate it.!