|
Calculating Vacation Entitlement
- We have a company that has a number of employee that are entitled to vacation after two months of employment.
- They are entitled 0.5833 days of vacation per month of employment.
- The first formula we will use edate which calculates the date that they will be able to take vacation.
edate(startdate, plus months)
-
Next we need to calculate how much vacation they are entitled to if they are passed this date
-
if today is greater that the date when they are able to take vacation,
then take the today's month and subtract the month of the start date
then multiply the result by the constant value
- The result is the number of vacation days that they are entitled.
 View instructions for Calculating Vacation Entitlement
|
