Jump to content
karenjoy

Calculation of Vacation allowed

Recommended Posts

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 by karenjoy

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Who Viewed the Topic

    1 member has viewed this topic:
    hutchlad 
×

Important Information

By using this site, you agree to our Terms of Use.