Spreadsheet: 786810d1657460952-calculate-workdays-without-overlap-in-a-single-row-oeter-example-pcb-sanity-check
Sheet: Sheet2

Fully Submitted | Total STC (which includes overlap, not what I want) | Expected | [NAME]'s formula | TOTAL STC DAYS (Excluding overlap) | STC Start 1 | STC End 1 | STC  Days 1 ([NAME]. Weekends / Holidays) | Who, Why? | STC Start 2 | STC End 2 | STC  Days 1 ([NAME]. Weekends / Holidays)2 | Who, Why?2 | STC Start 3 | STC End 3 | STC  Days 1 ([NAME]. Weekends / Holidays)3 | Who, Why?3 | STC Start 4 | STC End 4 | STC  Days 1 ([NAME]. Weekends / Holidays)4 | Who, Why?4 | helper1 | helper2
2022-04-01 00:00:00 |  | 5 |  |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00
2022-04-01 00:00:00 |  | 5 |  |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00 |  |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00
2022-04-01 00:00:00 |  | 8 |  |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00 |  |  | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 |  |  | 2022-07-08 00:00:00 | 2022-07-13 00:00:00
2022-04-01 00:00:00 |  | 11 |  |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00 |  |  | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 |  |  | 2022-07-08 00:00:00 | 2022-07-13 00:00:00 |  |  | 2022-07-20 00:00:00 | 2022-07-22 00:00:00
2022-04-01 00:00:00 |  | 15 |  |  | 2022-07-04 00:00:00 | 2022-07-08 00:00:00 |  |  | 2022-07-04 00:00:00 | 2022-07-05 00:00:00 |  |  | 2022-07-08 00:00:00 | 2022-07-13 00:00:00 |  |  | 2022-07-12 00:00:00 | 2022-07-22 00:00:00
2020-05-19 00:00:00 |  |  |  |  | 2020-06-03 00:00:00 | 2021-08-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculates correctly
2020-05-19 00:00:00 |  |  |  |  | 2021-09-01 00:00:00 | 2021-09-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculates correctly
2020-05-19 00:00:00 |  |  |  |  | 2021-10-11 00:00:00 | 2022-04-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calculates correctly
2020-05-19 00:00:00 |  |  |  |  | 2020-06-03 00:00:00 | 2021-08-27 00:00:00 |  |  | 2021-10-11 00:00:00 | 2022-04-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Noting, no overlap. Provides wrong total
2020-05-19 00:00:00 |  |  |  |  | 2020-06-03 00:00:00 | 2021-08-27 00:00:00 |  |  | 2021-09-01 00:00:00 | 2021-09-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Noting, no overlap. Provides wrong total
2020-05-19 00:00:00 |  |  |  |  | 2020-06-03 00:00:00 | 2021-08-27 00:00:00 |  |  | 2021-09-01 00:00:00 | 2021-09-14 00:00:00 |  |  | 2021-10-11 00:00:00 | 2022-04-06 00:00:00 |  |  |  |  |  |  |  | Noting, no overlap. Also, if I remove the dates in J and K, the total remains 447 (so is completely disregarding it?)
2020-05-19 00:00:00 |  |  |  |  | 2020-06-03 00:00:00 | 2021-08-27 00:00:00 |  |  | 2021-09-01 00:00:00 | 2021-09-14 00:00:00 |  |  | 2021-10-11 00:00:00 | 2022-04-06 00:00:00 |  |  | 2022-02-02 00:00:00 | 2022-03-06 00:00:00 |  |  |  | By adding a fourth STC, which overlaps the third one, it reduces the number, but am not sure it's even right then.
2020-05-19 00:00:00 |  |  |  |  | 2020-04-03 00:00:00 | 2020-06-03 00:00:00 |  |  | 2020-07-04 00:00:00 | 2020-09-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | I thought it MAY have been because the STCS are over holidays, but the dates in this row are not over holidays and still break it.