Spreadsheet: 820486d1678123286-assistance-needed-with-date-formula-s-excel-forum-assistance-with-date-formula
Sheet: SchoolgoingInland-Office

Start Date | End Date | Total Absent Days | Extra days qualified for
2022-11-18 00:00:00 | 2022-12-30 00:00:00 | 28 |  |  | School holiday Start date | 2022-12-15 00:00:00
2022-11-28 00:00:00 | 2023-01-04 00:00:00 | 24 |  |  | School holiday End date | 2023-01-10 00:00:00
2022-12-02 00:00:00 | 2023-01-09 00:00:00 | 23
2022-12-04 00:00:00 | 2022-12-23 00:00:00 | 14 |  |  | Public holidays | 2022-12-16 00:00:00
2022-12-05 00:00:00 | 2022-12-13 00:00:00 | 7 |  |  |  | 2022-12-25 00:00:00
2022-12-05 00:00:00 | 2022-12-30 00:00:00 | 17 |  |  |  | 2022-12-26 00:00:00
2022-12-06 00:00:00 | 2023-01-03 00:00:00 | 17 |  |  |  | 2022-12-27 00:00:00
2022-12-07 00:00:00 | 2022-12-30 00:00:00 | 15 |  |  |  | 2023-01-01 00:00:00
2022-12-07 00:00:00 | 2022-12-31 00:00:00 | 15 |  |  |  | 2023-01-02 00:00:00
2022-12-08 00:00:00 | 2022-12-30 00:00:00 | 14
2022-12-08 00:00:00 | 2023-01-04 00:00:00 | 16 |  |  | 1 day extra for every 4 days
2022-12-08 00:00:00 | 2023-01-06 00:00:00 | 18
2022-12-09 00:00:00 | 2022-12-30 00:00:00 | 13
2022-12-09 00:00:00 | 2023-01-04 00:00:00 | 15
2022-12-12 00:00:00 | 2022-12-15 00:00:00 | 4
2022-12-12 00:00:00 | 2022-12-19 00:00:00 | 5
2022-12-12 00:00:00 | 2022-12-26 00:00:00 | 9
2022-12-12 00:00:00 | 2022-12-27 00:00:00 | 9
2022-12-12 00:00:00 | 2022-12-30 00:00:00 | 12
2022-12-12 00:00:00 | 2022-12-31 00:00:00 | 12
2022-12-12 00:00:00 | 2023-01-02 00:00:00 | 12
2022-12-12 00:00:00 | 2023-01-06 00:00:00 | 16
2022-12-12 00:00:00 | 2023-01-10 00:00:00 | 18
2022-12-12 00:00:00 | 2023-01-13 00:00:00 | 21
2022-12-13 00:00:00 | 2022-12-23 00:00:00 | 8
2022-12-13 00:00:00 | 2022-12-26 00:00:00 | 8
2022-12-13 00:00:00 | 2023-01-06 00:00:00 | 15
2022-12-14 00:00:00 | 2022-12-30 00:00:00 | 10
2022-12-14 00:00:00 | 2023-01-04 00:00:00 | 12
2022-12-14 00:00:00 | 2023-01-05 00:00:00 | 13
2022-12-14 00:00:00 | 2023-01-06 00:00:00 | 14
2022-12-14 00:00:00 | 2023-01-10 00:00:00 | 16
2022-12-14 00:00:00 | 2023-01-16 00:00:00 | 20
2022-12-15 00:00:00 | 2022-12-21 00:00:00 | 4
2022-12-15 00:00:00 | 2022-12-30 00:00:00 | 9
2022-12-15 00:00:00 | 2023-01-02 00:00:00 | 9
2022-12-15 00:00:00 | 2023-01-06 00:00:00 | 13
2022-12-15 00:00:00 | 2023-01-09 00:00:00 | 14
2022-12-15 00:00:00 | 2023-01-10 00:00:00 | 15
2022-12-15 00:00:00 | 2023-01-13 00:00:00 | 18
2022-12-16 00:00:00 | 2023-01-11 00:00:00 | 15
2022-12-18 00:00:00 | 2023-01-16 00:00:00 | 18
2022-12-19 00:00:00 | 2022-12-22 00:00:00 | 4
2022-12-19 00:00:00 | 2022-12-23 00:00:00 | 5
2022-12-19 00:00:00 | 2022-12-30 00:00:00 | 8
2022-12-19 00:00:00 | 2022-12-31 00:00:00 | 8
2022-12-19 00:00:00 | 2023-01-03 00:00:00 | 9
2022-12-19 00:00:00 | 2023-01-04 00:00:00 | 10
2022-12-19 00:00:00 | 2023-01-05 00:00:00 | 11
2022-12-19 00:00:00 | 2023-01-06 00:00:00 | 12
2022-12-19 00:00:00 | 2023-01-09 00:00:00 | 13
2022-12-19 00:00:00 | 2023-01-10 00:00:00 | 14
2022-12-19 00:00:00 | 2023-01-11 00:00:00 | 15
2022-12-19 00:00:00 | 2023-01-13 00:00:00 | 17
2022-12-19 00:00:00 | 2023-01-16 00:00:00 | 18
2022-12-19 00:00:00 | 2023-01-17 00:00:00 | 19
2022-12-19 00:00:00 | 2023-01-20 00:00:00 | 22
2022-12-20 00:00:00 | 2022-12-23 00:00:00 | 4
2022-12-20 00:00:00 | 2022-12-30 00:00:00 | 7
2022-12-20 00:00:00 | 2023-01-04 00:00:00 | 9
2022-12-20 00:00:00 | 2023-01-06 00:00:00 | 11
2022-12-20 00:00:00 | 2023-01-09 00:00:00 | 12
2022-12-20 00:00:00 | 2023-01-13 00:00:00 | 16
2022-12-21 00:00:00 | 2022-12-30 00:00:00 | 6
2022-12-21 00:00:00 | 2023-01-03 00:00:00 | 7
2022-12-21 00:00:00 | 2023-01-06 00:00:00 | 10
2022-12-21 00:00:00 | 2023-01-09 00:00:00 | 11
2022-12-21 00:00:00 | 2023-01-13 00:00:00 | 15
2022-12-21 00:00:00 | 2023-01-17 00:00:00 | 17
2022-12-21 00:00:00 | 2023-01-20 00:00:00 | 20
2022-12-22 00:00:00 | 2022-12-30 00:00:00 | 5
2022-12-22 00:00:00 | 2022-12-31 00:00:00 | 5
2022-12-22 00:00:00 | 2023-01-03 00:00:00 | 6
2022-12-22 00:00:00 | 2023-01-06 00:00:00 | 9
2022-12-22 00:00:00 | 2023-01-09 00:00:00 | 10
2022-12-22 00:00:00 | 2023-01-10 00:00:00 | 11
2022-12-22 00:00:00 | 2023-01-11 00:00:00 | 12
2022-12-22 00:00:00 | 2023-01-13 00:00:00 | 14
2022-12-22 00:00:00 | 2023-01-17 00:00:00 | 16
2022-12-23 00:00:00 | 2022-12-30 00:00:00 | 4
2022-12-23 00:00:00 | 2023-01-03 00:00:00 | 5
2022-12-23 00:00:00 | 2023-01-04 00:00:00 | 6
2022-12-23 00:00:00 | 2023-01-06 00:00:00 | 8
2022-12-23 00:00:00 | 2023-01-13 00:00:00 | 13
2022-12-23 00:00:00 | 2023-01-23 00:00:00 | 19
2022-12-25 00:00:00 | 2023-01-13 00:00:00 | 12
2022-12-27 00:00:00 | 2023-01-04 00:00:00 | 5
2022-12-27 00:00:00 | 2023-01-06 00:00:00 | 7
2022-12-27 00:00:00 | 2023-01-09 00:00:00 | 8
2022-12-27 00:00:00 | 2023-01-12 00:00:00 | 11
2022-12-27 00:00:00 | 2023-01-13 00:00:00 | 12
2022-12-28 00:00:00 | 2023-01-03 00:00:00 | 4
2022-12-28 00:00:00 | 2023-01-04 00:00:00 | 5
2022-12-28 00:00:00 | 2023-01-06 00:00:00 | 7
2022-12-28 00:00:00 | 2023-01-09 00:00:00 | 8
2022-12-28 00:00:00 | 2023-01-10 00:00:00 | 9
2022-12-28 00:00:00 | 2023-01-11 00:00:00 | 10
2022-12-28 00:00:00 | 2023-01-13 00:00:00 | 12
2022-12-28 00:00:00 | 2023-01-20 00:00:00 | 17
2022-12-29 00:00:00 | 2023-01-09 00:00:00 | 7
2022-12-29 00:00:00 | 2023-01-11 00:00:00 | 9
2023-01-01 00:00:00 | 2023-01-06 00:00:00 | 4
2023-01-01 00:00:00 | 2023-01-08 00:00:00 | 4
2023-01-01 00:00:00 | 2023-01-09 00:00:00 | 5
2023-01-01 00:00:00 | 2023-01-16 00:00:00 | 10
2023-01-02 00:00:00 | 2023-01-06 00:00:00 | 4
2023-01-02 00:00:00 | 2023-01-09 00:00:00 | 5
2023-01-02 00:00:00 | 2023-01-10 00:00:00 | 6
2023-01-02 00:00:00 | 2023-01-13 00:00:00 | 9
2023-01-03 00:00:00 | 2023-01-06 00:00:00 | 4
2023-01-03 00:00:00 | 2023-01-09 00:00:00 | 5
2023-01-03 00:00:00 | 2023-01-10 00:00:00 | 6
2023-01-03 00:00:00 | 2023-01-11 00:00:00 | 7
2023-01-03 00:00:00 | 2023-01-13 00:00:00 | 9
2023-01-03 00:00:00 | 2023-01-16 00:00:00 | 10
2023-01-04 00:00:00 | 2023-01-09 00:00:00 | 4
2023-01-04 00:00:00 | 2023-01-10 00:00:00 | 5
2023-01-04 00:00:00 | 2023-01-11 00:00:00 | 6
2023-01-04 00:00:00 | 2023-01-13 00:00:00 | 8
2023-01-04 00:00:00 | 2023-01-17 00:00:00 | 10
2023-01-04 00:00:00 | 2023-01-20 00:00:00 | 13
2023-01-04 00:00:00 | 2023-01-27 00:00:00 | 18
2023-01-05 00:00:00 | 2023-01-10 00:00:00 | 4
2023-01-05 00:00:00 | 2023-01-11 00:00:00 | 5
2023-01-05 00:00:00 | 2023-01-13 00:00:00 | 7
2023-01-05 00:00:00 | 2023-01-18 00:00:00 | 10
2023-01-09 00:00:00 | 2023-01-13 00:00:00 | 5
2023-01-09 00:00:00 | 2023-01-25 00:00:00 | 13
2023-01-10 00:00:00 | 2023-01-13 00:00:00 | 4
2023-01-11 00:00:00 | 2023-01-18 00:00:00 | 6
2023-01-12 00:00:00 | 2023-01-17 00:00:00 | 4