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

Holidays in 2016 (From 1/9)
Labour Day | 2016-10-03 00:00:00
Christmas Closure | 2016-12-24 00:00:00
 | 2016-12-25 00:00:00
 | 2016-12-26 00:00:00
 | 2016-12-27 00:00:00
 | 2016-12-28 00:00:00
 | 2016-12-29 00:00:00
 | 2016-12-30 00:00:00
 | 2016-12-31 00:00:00
Holidays in 2017
Christmas Closure | 2017-01-01 00:00:00
 | 2017-01-02 00:00:00
 | 2017-01-03 00:00:00
 | 2017-01-04 00:00:00
 | 2017-01-05 00:00:00
 | 2017-01-06 00:00:00
 | 2017-01-07 00:00:00
 | 2017-01-08 00:00:00
Australia Day | 2017-01-26 00:00:00
Good Friday | 2017-04-14 00:00:00
Easter Saturday | 2017-04-15 00:00:00
Easter Sunday | 2017-04-16 00:00:00
Easter Monday | 2017-04-17 00:00:00
ANZAC Day | 2017-04-25 00:00:00
Queens Birthday | 2017-06-12 00:00:00
Labour Day | 2017-10-02 00:00:00
Christmas Closure | 2017-12-25 00:00:00
 | 2017-12-26 00:00:00
 | 2017-12-27 00:00:00
 | 2017-12-28 00:00:00
 | 2017-12-29 00:00:00
 | 2017-12-30 00:00:00
 | 2017-12-31 00:00:00
Holidays in 2018
Christmas Closure | 2018-01-01 00:00:00
 | 2018-01-02 00:00:00
 | 2018-01-03 00:00:00
 | 2018-01-04 00:00:00
 | 2018-01-05 00:00:00
 | 2018-01-06 00:00:00
 | 2018-01-07 00:00:00
 | 2018-01-08 00:00:00
Australia Day | 2018-01-26 00:00:00
Good Friday | 2018-03-30 00:00:00
Easter Saturday | 2018-03-31 00:00:00
Easter Sunday | 2018-04-01 00:00:00
Easter Monday | 2018-04-02 00:00:00
ANZAC Day | 2018-04-25 00:00:00
Queens Birthday | 2018-06-11 00:00:00
Labour Day | 2018-10-01 00:00:00
Christmas Closure | 2018-12-24 00:00:00
 | 2018-12-25 00:00:00
 | 2018-12-26 00:00:00
 | 2018-12-27 00:00:00
 | 2018-12-28 00:00:00
 | 2018-12-29 00:00:00
 | 2018-12-30 00:00:00
 | 2018-12-31 00:00:00
Holidays in 2019
Christmas Closure | 2019-01-01 00:00:00
 | 2019-01-02 00:00:00
 | 2019-01-03 00:00:00
 | 2019-01-04 00:00:00
Australia Day | 2019-01-28 00:00:00
Good Friday | 2019-04-19 00:00:00
Easter Saturday | 2019-04-20 00:00:00
Easter Sunday | 2019-04-21 00:00:00
Easter Monday | 2019-04-22 00:00:00
ANZAC Day | 2019-04-25 00:00:00
Queens Birthday | 2019-06-10 00:00:00
Labour Day | 2019-10-07 00:00:00
Christmas closure | 2019-12-23 00:00:00
 | 2019-12-24 00:00:00
 | 2019-12-25 00:00:00
 | 2019-12-26 00:00:00
 | 2019-12-27 00:00:00
 | 2019-12-28 00:00:00
 | 2019-12-29 00:00:00
 | 2019-12-30 00:00:00
 | 2019-12-31 00:00:00
Holidays in 2020
Christmas closure | 2020-01-01 00:00:00
 | 2020-01-02 00:00:00
 | 2020-01-03 00:00:00
Australia Day | 2020-01-27 00:00:00
Good Friday | 2020-04-10 00:00:00
Easter Saturday | 2020-04-11 00:00:00
Easter Sunday | 2020-04-12 00:00:00
Easter Monday | 2020-04-13 00:00:00
ANZAC Day | 2020-04-25 00:00:00
Queens Birthday | 2020-06-08 00:00:00
Labour Day | 2020-10-05 00:00:00
Christmas closure | 2020-12-25 00:00:00
 | 2020-12-26 00:00:00
 | 2020-12-27 00:00:00
 | 2020-12-28 00:00:00
 | 2020-12-29 00:00:00
 | 2020-12-30 00:00:00
 | 2020-12-31 00:00:00
Holidays in 2021
Christmas Closure | 2021-01-01 00:00:00
 | 2021-01-02 00:00:00
 | 2021-01-03 00:00:00
 | 2021-01-04 00:00:00
 | 2021-01-05 00:00:00
 | 2021-01-06 00:00:00
 | 2021-01-07 00:00:00
 | 2021-01-08 00:00:00
Australia Day | 2021-01-26 00:00:00
Good Friday | 2021-04-02 00:00:00
Easter Saturday | 2021-04-03 00:00:00
Easter Sunday | 2021-04-04 00:00:00
Easter Monday | 2021-04-05 00:00:00
ANZAC Day | 2021-04-25 00:00:00
Queens Birthday | 2021-06-14 00:00:00
Labour Day | 2021-10-04 00:00:00
Christmas closure | 2021-12-20 00:00:00
 | 2021-12-21 00:00:00
 | 2021-12-22 00:00:00
 | 2021-12-23 00:00:00
 | 2021-12-24 00:00:00
 | 2021-12-25 00:00:00
 | 2021-12-26 00:00:00
 | 2021-12-27 00:00:00
 | 2021-12-28 00:00:00
 | 2021-12-29 00:00:00
 | 2021-12-30 00:00:00
 | 2021-12-31 00:00:00
Holidays in 2022
Christmas Closure | 2022-01-01 00:00:00
 | 2022-01-02 00:00:00
 | 2022-01-03 00:00:00
 | 2022-01-04 00:00:00
 | 2022-01-05 00:00:00
 | 2022-01-06 00:00:00
 | 2022-01-07 00:00:00
Australia Day | 2022-01-26 00:00:00
Good Friday | 2022-04-15 00:00:00
Easter Saturday | 2022-04-16 00:00:00
Easter Sunday | 2022-04-17 00:00:00
Easter Monday | 2022-04-18 00:00:00
ANZAC Day | 2022-04-25 00:00:00
Queens Birthday | 2022-06-13 00:00:00
Test Holiday |  | 2022-07-07 00:00:00
Labour Day | 2022-10-03 00:00:00
Christmas Closure | 2022-12-26 00:00:00
 | 2022-12-27 00:00:00
 | 2022-12-28 00:00:00
 | 2022-12-29 00:00:00
 | 2022-12-30 00:00:00
 | 2022-12-31 00:00:00
Holidays in 2023
Christmas Closure | 2023-01-01 00:00:00
 | 2023-01-02 00:00:00
 | 2023-01-03 00:00:00
 | 2023-01-04 00:00:00
 | 2023-01-05 00:00:00
 | 2023-01-06 00:00:00
Australia Day | 2023-01-26 00:00:00
Good Friday | 2023-04-07 00:00:00
Easter Saturday | 2023-04-08 00:00:00
Easter Sunday | 2023-04-09 00:00:00
Easter Monday | 2023-04-10 00:00:00
ANZAC Day | 2023-04-25 00:00:00
Queens Birthday | 2023-06-12 00:00:00
Labour Day | 2023-10-02 00:00:00