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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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