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)
3This 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)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
Sumary of Annual Leave--Sample.x ls
Approval of Annual Leave.docx
LEAVE ENCASHMENT NOT INCLUDED IN WAGES FOR P. F. CALCULATION.pdf