Hello All,
We have a leave policy as follows; please note that we credit leaves at the beginning of every year:
- PL: 28
- SL: 7
* Out of 28 PL, only 18 will be carried forward to the next year.
* The maximum accumulation of PL is 50, and for SL, it is 28.
Please assist me with an Excel formula for prorating leave entitlement for employees who join in the middle of the year.
From India, Bhopal
Acknowledge(0)
Amend(0)
We have a leave policy as follows; please note that we credit leaves at the beginning of every year:
- PL: 28
- SL: 7
* Out of 28 PL, only 18 will be carried forward to the next year.
* The maximum accumulation of PL is 50, and for SL, it is 28.
Please assist me with an Excel formula for prorating leave entitlement for employees who join in the middle of the year.
From India, Bhopal
Acknowledge(0)Amend(0)
Hi,
This formula will be based on year calculation. Type of leave & Qty - PL-28 Number of month in year - 12 Starting of leave calculation (suppose) - April Joining month (suppose) - November So calculation - 28/12 * (Nov. to Mar. balance months) 28/12 * (6) 12 leaves can be provided. Please calculate the average date for joining in the middle of the month.
From India, Uran
Acknowledge(0)Amend(0)
2This formula will be based on year calculation. Type of leave & Qty - PL-28 Number of month in year - 12 Starting of leave calculation (suppose) - April Joining month (suppose) - November So calculation - 28/12 * (Nov. to Mar. balance months) 28/12 * (6) 12 leaves can be provided. Please calculate the average date for joining in the middle of the month.
From India, Uran
Acknowledge(0)Amend(0)Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.