Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381

Warning: preg_replace(): Empty regular expression in [path]/showthread.php on line 2381
Annual Leave on prorata calculation for new joining in between the calendar year - CiteHR

No Tags Found!

SH

Shai89308

Executive Hr

AS

Ammu Shanvi

Human Resource

GS

G SHASHI KRISHNA

Senior Manager - Hr

AH

Aizant HR

Human Resources

MA

MARSHAL

Safety Officer

AK

Anish Katoch

Hr Executive

PR

PranjalR

Hr Recruiter

AP

Alka Pal

Hr Executive

Karthikeyan8195

Management Consultant

MK

Mohit Kumar Puri

Head Marketing

AU

Austex

Accounts Manager


ankitasharmagarg
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

From India, Bhopal
ganeshgpatil
2

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 leave can provide
Pls calculate average date for joining in middle of month.

From India, Uran
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.




About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.