Spreadsheet: 843533d1695316820-sum-month-wise-total-days-of-leave-taken-between-two-dates-problem_leave-expander
Sheet: Sheet1

levType | leaveFrom | leaveUpto | leaveDays |  | Month | SL (HP) | ML | ELD | STD | CL | PL | SL (FP) | Total Days Leave Taken
SL (HP) | 25/02/2021 Forenoon | 26/03/2021 Afternoon | 30 |  | 2021-02-28 00:00:00 | 4 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | I want to calculte month wise Leave type wise total no of leaves taken, there might be situation that leave might be taken for many months at a time,there could be half days
ML | 31/03/2021 Forenoon | 24/09/2021 Afternoon | 178 |  |  | 26 | 1 | 0 | 0 | 0 | 0 | 0
ELD | 27/09/2021 Forenoon | 23/12/2021 Afternoon | 88 |  |  | 0 | 30 | 0 | 0 | 0 | 0 | 0
ELD | 27/12/2021 Forenoon | 24/03/2022 Afternoon | 88 |  |  | 0 | 31 | 0 | 0 | 0 | 0 | 0
STD | 28/03/2022 Forenoon | 29/03/2022 Afternoon | 2 |  |  | 0 | 30 | 0 | 0 | 0 | 0 | 0
CL | 04/04/2022 Forenoon | 04/04/2022 Afternoon | 1 |  |  | 0 | 31 | 0 | 0 | 0 | 0 | 0
CL | 11/04/2022 Forenoon | 13/04/2022 Afternoon | 3 |  |  | 0 | 31 | 0 | 0 | 0 | 0 | 0
CL | 18/04/2022 Forenoon | 19/04/2022 Afternoon | 2 |  |  | 0 | 24 | 4 | 0 | 0 | 0 | 0
CL | [NAME] | 29/04/2022 Afternoon | 5
CL | 04/05/2022 Forenoon | 05/05/2022 Afternoon | 2
CL | 16/05/2022 Forenoon | 16/05/2022 Afternoon | 1
CL | 21/06/2022 Forenoon | 21/06/2022 Afternoon | 1
PL | 24/06/2022 Forenoon | 24/06/2022 Afternoon | 1
PL | 30/06/2022 Forenoon | 30/06/2022 Afternoon | 1
SL (FP) | 01/07/2022 Forenoon | 01/07/2022 Afternoon | 1
SL (HP) | 11/07/2022 Forenoon | 22/07/2022 Afternoon | 12
CL | 28/07/2022 Forenoon | 28/07/2022 Afternoon | 1
CL | 05/08/2022 Forenoon | 05/08/2022 Forenoon | 0.5
CL | 08/08/2022 Forenoon | 08/08/2022 Afternoon | 1
CL | 16/08/2022 Forenoon | 18/08/2022 Afternoon | 3
SL (HP) | [NAME] | 31/08/2022 Afternoon | 7
PL | 01/09/2022 Forenoon | 09/09/2022 Afternoon | 9
CL | 29/09/2022 Forenoon | 30/09/2022 Afternoon | 2
CL | 06/10/2022 Forenoon | 06/10/2022 Afternoon | 1
CL | 13/10/2022 Forenoon | 13/10/2022 Afternoon | 1
CL | 17/10/2022 Forenoon | 18/10/2022 Afternoon | 2
CL | 26/10/2022 Forenoon | 27/10/2022 Afternoon | 2
PL | 31/10/2022 Forenoon | 04/11/2022 Afternoon | 5
CL | 11/11/2022 Forenoon | 11/11/2022 Afternoon | 1
PL | [NAME] | 28/11/2022 Afternoon | 1
SL (HP) | 05/12/2022 Forenoon | 05/12/2022 Afternoon | 1
SL (HP) | 19/12/2022 Forenoon | 19/12/2022 Afternoon | 1
PL | 16/01/2023 Forenoon | 23/01/2023 Afternoon | 8
SL (HP) | 24/01/2023 Forenoon | 27/01/2023 Afternoon | 4
SL (HP) | 31/01/2023 Forenoon | 31/01/2023 Afternoon | 1
SL (HP) | 06/02/2023 Forenoon | 10/02/2023 Afternoon | 5
SL (HP) | 20/02/2023 Forenoon | 21/02/2023 Afternoon | 2
SL (FP) | 23/02/2023 Forenoon | 24/02/2023 Afternoon | 2
PL | 13/03/2023 Forenoon | 14/03/2023 Afternoon | 2
SL (HP) | 21/03/2023 Forenoon | 24/03/2023 Afternoon | 4
SL (HP) | 29/03/2023 Forenoon | 29/03/2023 Afternoon | 1
SL (HP) | 06/04/2023 Forenoon | 06/04/2023 Afternoon | 1
SL (HP) | 13/04/2023 Forenoon | 13/04/2023 Afternoon | 1
SL (HP) | 18/04/2023 Forenoon | 21/04/2023 Afternoon | 4
SL (HP) | 28/04/2023 Forenoon | 28/04/2023 Afternoon | 1
SL (HP) | 02/05/2023 Forenoon | 02/05/2023 Afternoon | 1
SL (HP) | 09/05/2023 Forenoon | 09/05/2023 Afternoon | 1
SL (HP) | 15/05/2023 Forenoon | 16/05/2023 Afternoon | 2
SL (HP) | 25/05/2023 Forenoon | 26/05/2023 Afternoon | 2
SL (HP) | 20/06/2023 Forenoon | 21/06/2023 Afternoon | 2
PL | 22/06/2023 Forenoon | 22/06/2023 Afternoon | 1
PL | 26/06/2023 Forenoon | 30/06/2023 Afternoon | 5
CL | 17/08/2023 Forenoon | 18/08/2023 Afternoon | 2
CL | 23/08/2023 Forenoon | 23/08/2023 Afternoon | 1
CL | 31/08/2023 Forenoon | 01/09/2023 Afternoon | 2
CL | 04/09/2023 Forenoon | 04/09/2023 Afternoon | 1