Hi, I urgently need to know how I would calculate the pro rate annual leave for someone who has joined, say in July. Total number of leave days per year is 20, and it is from jan - Dec.
If 20 leaves are there in a year..
Then on pro-rata basis it will be calculated as below-
For every month it would be- 20/12 = 1.67 (Approx)..
So if some one joined in July then he would be eligible for only 6 months leave in that calender year and that would be 10..
If someone joined on 1st August, then every month he would be eligible to avail 1.7 leaves..
Hope now the calculation of leaves on pro-rata basis has been cleared with you upto an extent.
Yes it is been calculated on number of days of length of service.. If someone has joined in the 1st week then only he will be eligible for that month complete leave of 1.7..
If one has joined on 21st.. then for that calender year his leave would be
Leave = 20/365*345 = 18.9 and in round figure it would be 19.
So, your company is giving the exact number of leaves he is eligible for..
Hope now it must be clear with you..
Another example: someone who joined on 22nd july 2007 is entitled to 9 days (163 days). Is this correct?
Thank you for all your help, and sorry to ask so many questions!
I have to calculate the leave from the date 01-01-07 to 13-07-2007.We have a policy of 30days leave in our orgn.
Is there any other ways to calculate the leave other than calculating the total no days i.e. till 13/07/2007.
for eg Normally what i do is =31+28+31+30+31+30+13 *30/365.
Please help me if any one has a simpler calculation.
Why Vote? User validation is extremely important for good content to prosper.