Annual Leave on prorata calculation for new joining in between the calendar year - CiteHR
Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Hello All,
We have leave policy is as follows, also note we credit leaves at the starting of every year
PL: 28
SL: 7
* Out of 28 PL only 18 will be carry forwarded next year.
*Maximum accumulation of PL is 50 and SL is 28.
Please help me with excel formula for prorate leave entitlement formula for employees who join in middle of the year
Community Prime Sponsors - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA.
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)
12 leave can provide
Pls calculate average date for joining in middle of month.
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™