View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Jaleel Jaleel is offline
external usenet poster
 
Posts: 187
Default Vacation Pay Calculation

Thank you for your explanation. It will bring the result of ones
eligibility is either 14 or 21. That is not the main issue. Last entry is
also to be considered. Suppose, one fellow joined the company on 01/01/2000.
His last arrival from vacation is 01/01/2004. He is going for next vacation
on 01/01/2006. He is not fully eligible for 21 days pay. His first 5 years
will be completed on 01/01/2005. So for that period he will get only 14 days
pay. And for the rest of the period up to 01/01/2006 he is eligible for 21
days pay. This calculation is making the complication.

Jaleel


"sloth" wrote:

Tier2.year is a name for the year that vacation days turns from 14 to
21, or year 5.

Tier1.vac is a name for # of vacation days if time with co. is less
than 5 years
Tier2.vac is a name for # of vacation days if time with co. is greater
than or equal to 5 years

Disregard the names if it helps and just use the values, i.e. 14, 21,
and 5.