Anonymous
Hi team, Requesting expert's views and solutions for the below query at the earliest.

I want to calculate the balance for each leave type as on the following dates if the DOJ is 31-03-2016, considering he has not taken any leave and all leaves are carried forward. I am unable to calculate in an excel sheet along with the final balances.

Leave type 1-Casual leave 2-Sick Leave 3- Earned Leave
Annual Allotment 24 18 24
Pro-rata Yes Yes Yes
From DOJ DOJ DOJ
Accrual Quarterly Monthly Bi-annually
From Beginning of quarter. End of month Beginning of half-year
Leave cycle Financial year Financial year Calendar year

Date Balance- C/L Balance- S/L Balance- E/L
07-08-2017
25-12-2017
16-01-2018
05-05-2018
12-06-2018
19-07-2018
15-03-2019

From India, Karjat
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.