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
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