Hi All,
I am wanting to calculate the leave acquired by an employee on a month by month basis. The formula I am currently using however does cater for change in the accural calculator.
Example: Employees Acquire Leave as follows:
1 Year = 1.25 days per month
2 Years = 1.33 days per month
3 Years = 1.42 days per month
4 Years = 1.5 days per month
5 Years = 1.58 days per month
>=6 Years = 1.67 days per month
The calculation error happens when an employee crosses over to a new accural band as per the example:
Using a Start Date of 01/11/2012
From January to November of 2014 they will acquire leave at 1.33 days per annum, however when it gets to December their leave accural will increase to 1.42. I need to calculate their acquired leave at a rate of 1.33 for the first 11 months, and then at the new accural rate for the last month only. The accumulated leave should equal 16.05 and not 17.04 after the 12 month period.
Sample attached
Thanks
Bookmarks