Spreadsheet: 871709d1718125194-googlesheets-number-of-days-per-month-in-a-date-range-holidays-example
Sheet: Sheet1

 | HOLIDAYS |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-01 00:00:00 | 2024-06-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | 2024-06-03 00:00:00 | 2024-06-04 00:00:00 | 2024-06-05 00:00:00 | 2024-06-06 00:00:00 | 2024-06-07 00:00:00 | 2024-06-08 00:00:00 | 2024-06-09 00:00:00
 | Dates |  |  |  |  |  |  | Allocated Days |  | 30 |  | 2024-06-10 00:00:00 | 2024-06-11 00:00:00 | 2024-06-12 00:00:00 | 2024-06-13 00:00:00 | 2024-06-14 00:00:00 | 2024-06-15 00:00:00 | 2024-06-16 00:00:00
 | Start | End | Month 1 | Days | Month 2 | Days |  | Days Taken |  |  |  | 2024-06-17 00:00:00 | 2024-06-18 00:00:00 | 2024-06-19 00:00:00 | 2024-06-20 00:00:00 | 2024-06-21 00:00:00 | 2024-06-22 00:00:00 | 2024-06-23 00:00:00
 | 2024-02-08 00:00:00 | 2024-02-09 00:00:00 |  |  |  |  |  | Days Left |  |  |  | 2024-06-24 00:00:00 | 2024-06-25 00:00:00 | 2024-06-26 00:00:00 | 2024-06-27 00:00:00 | 2024-06-28 00:00:00 | 2024-06-29 00:00:00 | 2024-06-30 00:00:00
 | 2024-04-10 00:00:00 | 2024-04-10 00:00:00
 | 2024-04-22 00:00:00 | 2024-04-22 00:00:00 |  |  |  |  |  |  |  |  |  | July
 | 2024-05-07 00:00:00 | 2024-05-10 00:00:00 |  |  |  |  |  | Month |  | Days Taken |  | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
 | 2024-05-28 00:00:00 | 2024-06-07 00:00:00 |  |  |  |  |  | January |  |  |  | 2024-07-01 00:00:00 | 2024-07-02 00:00:00 | 2024-07-03 00:00:00 | 2024-07-04 00:00:00 | 2024-07-05 00:00:00 | 2024-07-06 00:00:00 | 2024-07-07 00:00:00
 |  |  |  |  |  |  |  | February |  |  |  | 2024-07-08 00:00:00 | 2024-07-09 00:00:00 | 2024-07-10 00:00:00 | 2024-07-11 00:00:00 | 2024-07-12 00:00:00 | 2024-07-13 00:00:00 | 2024-07-14 00:00:00
 |  |  |  |  |  |  |  | March |  |  |  | 2024-07-15 00:00:00 | 2024-07-16 00:00:00 | 2024-07-17 00:00:00 | 2024-07-18 00:00:00 | 2024-07-19 00:00:00 | 2024-07-20 00:00:00 | 2024-07-21 00:00:00
 |  |  |  |  |  |  |  | April |  |  |  | 2024-07-22 00:00:00 | 2024-07-23 00:00:00 | 2024-07-24 00:00:00 | 2024-07-25 00:00:00 | 2024-07-26 00:00:00 | 2024-07-27 00:00:00 | 2024-07-28 00:00:00
 |  |  |  |  |  |  |  | May |  |  |  | 2024-07-30 00:00:00 | 2024-07-31 00:00:00
 |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  | July |  |  |  | August
 |  |  |  |  |  |  |  | August |  |  |  | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun
 |  |  |  |  |  |  |  | September |  |  |  |  |  | 2024-08-01 00:00:00 | 2024-08-02 00:00:00 | 2024-08-03 00:00:00 | 2024-08-04 00:00:00 | 2024-08-05 00:00:00
 |  |  |  |  |  |  |  | October |  |  |  | 2024-08-06 00:00:00 | 2024-08-07 00:00:00 | 2024-08-08 00:00:00 | 2024-08-09 00:00:00 | 2024-08-10 00:00:00 | 2024-08-11 00:00:00 | 2024-08-12 00:00:00
 |  |  |  |  |  |  |  | November |  |  |  | 2024-08-13 00:00:00 | 2024-08-14 00:00:00 | 2024-08-15 00:00:00 | 2024-08-16 00:00:00 | 2024-08-17 00:00:00 | 2024-08-18 00:00:00 | 2024-08-19 00:00:00
 |  |  |  |  |  |  |  | December |  |  |  | 2024-08-20 00:00:00 | 2024-08-21 00:00:00 | 2024-08-22 00:00:00 | 2024-08-23 00:00:00 | 2024-08-24 00:00:00 | 2024-08-25 00:00:00 | 2024-08-26 00:00:00
 |  |  |  |  |  |  |  | Total Days |  |  |  | 2024-08-27 00:00:00 | 2024-08-28 00:00:00 | 2024-08-29 00:00:00 | 2024-08-30 00:00:00 | 2024-08-31 00:00:00