# Calculation of Annual Leave Entitlement

## Recommended Posts

Hello Guys.

I want to create a Calculation that will do the following

Each worker is entitled to 45 days holiday per year The standard annual leave entitlement for a full-time member of staff is 45 days including public holidays and customary days.

I would just like to be able to put his start date in a filed and then automatically generate how many days holiday he would be entitled and how many days remaining and the end date

I want to keep a history table for each worker when he took his leave and how many days he have.

Like this

1- Emp_Id emp_name , start_date , end_date , total_days, rem_dates

Hope this is enough info.

##### Share on other sites

The vacations history table needs only these fields:

• EmpID

• StartDate

• EndDate

• cTotalDays (calculation)

The calculation of remaining days should be done in the Employees table. Calculate how many years the employee has been employed, multiply by 45 and subtract Sum ( Vacations::cTotalDays ).

##### Share on other sites

Thank you very much for taking the time to reply to me. I really appreciate it

Can you please write The formula how to do the Annual leave calculation

and the The vacations history table .

##### Share on other sites

Is there a maximum number of days that they can have on the books before they lose them?

##### Share on other sites

There is not much else I could add. You already know how to calculate the number of years from here:

http://fmforums.com/forum/showpost.php?post/333464/

##### Share on other sites

Nope , theres NO maximum number of days that they can have on the books before they lose them?

##### Share on other sites

If you can help me how to do the history table please

##### Share on other sites

I am still waiting for the answer

##### Share on other sites

10 years later? If you haven't figured it out in 10 years then maybe time to hire someone?  lol  😂

## 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.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

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

×

×
×
• Create New...