Confused About Earned Leave Calculation with CL, SL, and Holidays? Let's Clarify!

Hi, I am calculating Earned Leave manually. Please let me know how we can calculate if an employee consumed -7 CL & 7 SL and Holidays (the company is providing 10-11 Holidays per year). How will we calculate EL in this case?

Calculating Earned Leave

Every 20 days present generate an EL. How do we calculate these 20 days? Are Sundays, Holidays, and their own leaves included in these 20 days or not? Please explain fully. I got confused after reading some responses stating that 240 days are required to calculate EL. How is it calculated and fixed as 240? Kindly mention if there is any formula.

In India, the calculation of Earned Leave (EL) is based on the number of days an employee has worked. Here's how you can calculate EL when an employee has consumed CL, SL, and Holidays:

1. Subtract the total number of Casual Leave (CL), Sick Leave (SL), and Holidays taken by the employee from the total working days in a year (considering 10-11 Holidays provided by the company).
2. Deduct these days from the total working days to get the actual working days.
3. For every 20 actual working days, the employee earns one day of Earned Leave.
4. Sundays, Holidays, and leaves taken by the employee are not considered as working days for EL calculation.
5. The 240 days mentioned for EL calculation is a standard practice where 20 working days are considered to earn one day of leave, totaling 240 working days for 12 days of EL per year.

Therefore, to calculate EL, subtract CL, SL, and Holidays from total working days, exclude non-working days, and follow the 20-day working cycle to determine earned leave entitlement accurately.