Know About How Each Employee Leave Calculate. - DOCX Download

We have IT company and shops and establishment act is applicable so i want to know that employee after 1 year Confirmation eligible for yearly 24 leaves so how it is distribute monthly ,
How much :-
Paid Leave :-
Sick Leave:-
Casual Leave :-
Please give me your suggestion .

HI
Please find the attached file.......

Thank you Sir,
Actually we calculate it on bases 24 days in year ,
12 Paid leave ,
6 Sick Leave ,
6 Casual Leave .
But actually it is applicable on confirm employee only.
And how it is applicable Actually on permanent employee .
So , how can and in which scenario confirm employee can use this Leaves during year .

Please find the attached files..........

Dear Bhavya
I have made an excel sheet for all these querry ,pls go through it ,it will automatically calculate ( by default ) Also manually ,leaves day ,
I hope this will solve your 99% problem.
Thanks
Anjani Singh

Dear Anjani Singh,
Pleased to inform you that it working very good but i dont no why it showing leavs less if you check jan to December.

during calendar year if one employee every 20 days worked in eight month and remaining four month every 18 days worked How to calculate Earned leave.

Dear Sir,
How many yearly leave provide to payroll employee and also monthly leave calculation confirm me.
Total yearly leave allotment=
Casual leave provided in on month =
Sick Leave provided in on month =
Previlage leave provided in on month =