How to Calculate Leave Balances in Excel for Different Types Since 2016?

Calculate the balance for each leave type

Calculate the balance for each leave type as of the following dates if the DOJ is 31-03-2016, considering no leave has been taken, and all leaves are carried forward. Please provide the calculations in an Excel sheet along with the final balances.

Leave Type

- Casual Leave
- Sick Leave
- Earned Leave

Annual Allotment

- Casual Leave: 24
- Sick Leave: 18
- Earned Leave: 24

Pro-rata

- Casual Leave: Yes
- Sick Leave: Yes
- Earned Leave: Yes

From

- Casual Leave: DOJ
- Sick Leave: DOJ
- Earned Leave: DOJ

Accrual

- Casual Leave: Quarterly
- Sick Leave: Monthly
- Earned Leave: Bi-annually

From

- Casual Leave: Beginning of quarter
- Sick Leave: End of month
- Earned Leave: Beginning of half-year

Leave Cycle

- Casual Leave: Financial year
- Sick Leave: Financial year
- Earned Leave: Calendar year

Date

- Balance - C/L
- Balance - S/L
- Balance - E/L

7/8/2017
25-12-2017
16-01-2018
5/5/2018
12/6/2018
19-07-2018
15-03-2019

I need an answer for this problem. Calculate the balance for each leave type on the following dates if the DOJ is 31-03-2016, considering he has not taken any leave and all leaves are carried forward. Please share the calculations in an Excel sheet along with the final balances.

Leave Type

Annual Allotment Pro-rata From Accrual

From Leave Cycle Date 07-08-2017 25-12-2017 16-01-2018 05-05-2018 12-06-2018 19-07-2018 15-03-2019

Casual Leave

24 Yes DOJ Quarterly Beginning of quarter Financial Year Balance - C/L

Sick Leave

18 Yes DOJ Monthly End of month Financial Year Balance - S/L

Earned Leave

I don't know whether my sheet is correct or not, but I tried my best. It might be helpful for you if my answer is correct.