Spreadsheet: 802067d1666622874-average-of-days-or-cells-in-a-table-on-call-sample
Sheet: Sheet1

Start | End | [NAME] | Sue | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Leo
2023-01-04 00:00:00 | 2023-01-11 00:00:00 |  |  |  |  |  |  |  |  | x |  |  |  |  |  | h = Holiday
2023-01-11 00:00:00 | 2023-01-18 00:00:00 |  |  |  |  |  |  |  | x |  |  |  |  |  |  | x = On Call Week
2023-01-18 00:00:00 | 2023-01-25 00:00:00 |  |  |  |  |  |  | x
2023-01-25 00:00:00 | 2023-02-01 00:00:00 |  |  |  | x |  |  |  |  |  |  |  |  |  |  | Would like average # of weeks between On Calls
2023-02-01 00:00:00 | 2023-02-08 00:00:00 |  |  |  |  |  | x |  |  |  |  |  |  |  |  | So that I can see everyone is getting about the same
2023-02-08 00:00:00 | 2023-02-15 00:00:00 |  |  |  |  |  |  |  |  |  | x |  |  |  |  | time in between.  Okay with any solution (formula, [NAME], etc.)
2023-02-15 00:00:00 | 2023-02-22 00:00:00 |  |  |  |  | x
2023-02-22 00:00:00 | 2023-03-01 00:00:00 | x
2023-03-01 00:00:00 | 2023-03-08 00:00:00 |  |  |  |  |  |  |  |  |  |  | x |  |  |  | Randomly checking most have 12 weeks between, but [NAME] for example has a span of 9 in there.
2023-03-08 00:00:00 | 2023-03-15 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Which is probably okay, but I want to confirm no one is getting off easy, or getting little time
2023-03-15 00:00:00 | 2023-03-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | x |  | between.
2023-03-22 00:00:00 | 2023-03-29 00:00:00 |  | x
2023-03-29 00:00:00 | 2023-04-05 00:00:00 |  |  | x
2023-04-05 00:00:00 | 2023-04-12 00:00:00 |  |  |  |  |  |  |  |  | h
2023-04-12 00:00:00 | 2023-04-19 00:00:00 |  |  |  |  |  |  |  | x
2023-04-19 00:00:00 | 2023-04-26 00:00:00 |  |  |  |  |  |  | x
2023-04-26 00:00:00 | 2023-05-03 00:00:00 |  |  |  | x
2023-05-03 00:00:00 | 2023-05-10 00:00:00 |  |  |  |  |  | x
2023-05-10 00:00:00 | 2023-05-17 00:00:00 |  |  |  |  |  |  |  |  |  | x
2023-05-17 00:00:00 | 2023-05-24 00:00:00 |  |  |  |  | x
2023-05-24 00:00:00 | 2023-05-31 00:00:00 | x
2023-05-31 00:00:00 | 2023-06-07 00:00:00 |  |  |  |  |  |  |  |  |  |  | x
2023-06-07 00:00:00 | 2023-06-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | x
2023-06-14 00:00:00 | 2023-06-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | x
2023-06-21 00:00:00 | 2023-06-28 00:00:00 |  | x
2023-06-28 00:00:00 | 2023-07-05 00:00:00 |  |  | h
2023-07-05 00:00:00 | 2023-07-12 00:00:00 |  |  |  |  |  |  |  |  | x
2023-07-12 00:00:00 | 2023-07-19 00:00:00 |  |  |  |  |  |  |  | x
2023-07-19 00:00:00 | 2023-07-26 00:00:00 |  |  |  |  |  |  | x
2023-07-26 00:00:00 | 2023-08-02 00:00:00 |  |  |  | x
2023-08-02 00:00:00 | 2023-08-09 00:00:00 |  |  |  |  |  | x
2023-08-09 00:00:00 | 2023-08-16 00:00:00 |  |  |  |  |  |  |  |  |  |  | x
2023-08-16 00:00:00 | 2023-08-23 00:00:00 |  |  |  |  | x
2023-08-23 00:00:00 | 2023-08-30 00:00:00 | x
2023-08-30 00:00:00 | 2023-09-06 00:00:00 |  |  |  |  |  |  |  |  |  | h
2023-09-06 00:00:00 | 2023-09-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | x
2023-09-13 00:00:00 | 2023-09-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | x
2023-09-20 00:00:00 | 2023-09-27 00:00:00 |  | x
2023-09-27 00:00:00 | 2023-10-04 00:00:00 |  |  | x
2023-10-04 00:00:00 | 2023-10-11 00:00:00 |  |  |  |  |  |  |  |  | x
2023-10-11 00:00:00 | 2023-10-18 00:00:00 |  |  |  |  |  |  |  | x
2023-10-18 00:00:00 | 2023-10-25 00:00:00 |  |  |  |  |  |  | x
2023-10-25 00:00:00 | 2023-11-01 00:00:00 |  |  |  | x
2023-11-01 00:00:00 | 2023-11-08 00:00:00 |  |  |  |  |  | x
2023-11-08 00:00:00 | 2023-11-15 00:00:00 |  |  |  |  |  |  |  |  |  | x
2023-11-15 00:00:00 | 2023-11-22 00:00:00 |  |  |  |  | x
2023-11-22 00:00:00 | 2023-11-29 00:00:00 | x
2023-11-29 00:00:00 | 2023-12-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | h
2023-12-06 00:00:00 | 2023-12-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | x
2023-12-13 00:00:00 | 2023-12-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | x
2023-12-20 00:00:00 | 2023-12-27 00:00:00 |  | h
2023-12-27 00:00:00 | 2024-01-03 00:00:00 |  |  | h