HOW TO CALCULATE PRORATED VACATION DAYS DEPENDING ON A START DATE

[Guest]

Hello,

I am creating a dbase for emp vacation tracking. Please if anyone knows how
to calculate prorated vacation entitlement for an employee depending on his
start date that would be a great help.For eg: if an employee is eligible 15
days for a year but he joined sometime in the middle of the year say June.So
now his vacation entitlement woould become 8 days instead of 15.

 

[Guest]

You don't provide nearly enough business rules to know how to do the
calculation. In most such cases, an employee get a number of days or hours
based on number of days or months of service, and length of service.

 

[Guest]

hi,

Actually this is the rules for eligible vac days:

years of service <= 5yrs -----15 days entitlement
years of service between 5 and 20yrs ----20 days
years of service > 20 yrs ----25 days

So my question is what if he joins in the middle of the year say April 24th?
he will not get the 15 days but he will get prorated vac. days.

 

[Guest]

Okay, that is part of it, but depending on the business rules, the days
eligible may be allocated differently. I have seen cases where the
allocation is awarded on anniversary dates, where it is on a calendar date
and a prorated number of days is awarded, and other cases where a number of
days is awarded at the end of each calendar month.

 

[jahoobob via AccessMonster.com]

If this applies to only the first year then:
EligbleDays = (DateSerial(Year(Date), 12, 31) - HireDate) * 15 / 364

hi,

Actually this is the rules for eligible vac days:

years of service <= 5yrs -----15 days entitlement
years of service between 5 and 20yrs ----20 days
years of service > 20 yrs ----25 days

So my question is what if he joins in the middle of the year say April 24th?
he will not get the 15 days but he will get prorated vac. days.

You don't provide nearly enough business rules to know how to do the
calculation. In most such cases, an employee get a number of days or hours

[quoted text clipped - 7 lines]