Spreadsheet: 861470d1709310096-gnatt-chart-bar-color-schedule_2_2024
Sheet: Holidays

Holidays to Exclude from Work Days
If you add more rows to the bottom of the list, you may need to
edit the named range "holidays" via [NAME] > Named Ranges.
to include the new rows. The Description column is just for reference.
Date | Description | Country
2014-12-25 00:00:00 | Christmas
2015-12-25 00:00:00 | Christmas
2016-12-25 00:00:00 | Christmas
2017-12-25 00:00:00 | Christmas
2018-12-25 00:00:00 | Christmas
2019-12-25 00:00:00 | Christmas
2020-12-25 00:00:00 | Christmas
2014-10-13 00:00:00 | Columbus Day | US
2015-10-12 00:00:00 | Columbus Day | US
2016-10-10 00:00:00 | Columbus Day | US
2017-10-09 00:00:00 | Columbus Day | US
2018-10-08 00:00:00 | Columbus Day | US
2019-10-14 00:00:00 | Columbus Day | US
2020-10-12 00:00:00 | Columbus Day | US
2014-07-04 00:00:00 | Independence Day | US
2015-07-04 00:00:00 | Independence Day | US
2016-07-04 00:00:00 | Independence Day | US
2017-07-04 00:00:00 | Independence Day | US
2018-07-04 00:00:00 | Independence Day | US
2019-07-04 00:00:00 | Independence Day | US
2020-07-04 00:00:00 | Independence Day | US
2014-09-01 00:00:00 | Labor Day | US
2015-09-07 00:00:00 | Labor Day | US
2016-09-05 00:00:00 | Labor Day | US
2017-09-04 00:00:00 | Labor Day | US
2018-09-03 00:00:00 | Labor Day | US
2019-09-02 00:00:00 | Labor Day | US
2020-09-07 00:00:00 | Labor Day | US
2014-01-20 00:00:00 | M.L.King Jr. Day | US
2015-01-19 00:00:00 | M.L.King Jr. Day | US
2016-01-18 00:00:00 | M.L.King Jr. Day | US
2017-01-16 00:00:00 | M.L.King Jr. Day | US
2018-01-15 00:00:00 | M.L.King Jr. Day | US
2019-01-21 00:00:00 | M.L.King Jr. Day | US
2020-01-20 00:00:00 | M.L.King Jr. Day | US
2014-05-26 00:00:00 | Memorial Day | US
2015-05-25 00:00:00 | Memorial Day | US
2016-05-30 00:00:00 | Memorial Day | US
2017-05-29 00:00:00 | Memorial Day | US
2018-05-28 00:00:00 | Memorial Day | US
2019-05-27 00:00:00 | Memorial Day | US
2020-05-25 00:00:00 | Memorial Day | US
2014-01-01 00:00:00 | New Year's Day
2015-01-01 00:00:00 | New Year's Day
2016-01-01 00:00:00 | New Year's Day
2017-01-01 00:00:00 | New Year's Day
2018-01-01 00:00:00 | New Year's Day
2019-01-01 00:00:00 | New Year's Day
2020-01-01 00:00:00 | New Year's Day
2014-02-17 00:00:00 | Presidents Day | US
2015-02-16 00:00:00 | Presidents Day | US
2016-02-15 00:00:00 | Presidents Day | US
2017-02-20 00:00:00 | Presidents Day | US
2018-02-19 00:00:00 | Presidents Day | US
2019-02-18 00:00:00 | Presidents Day | US
2020-02-17 00:00:00 | Presidents Day | US
2014-11-27 00:00:00 | Thanksgiving | US
2015-11-26 00:00:00 | Thanksgiving | US
2016-11-24 00:00:00 | Thanksgiving | US
2017-11-23 00:00:00 | Thanksgiving | US
2018-11-22 00:00:00 | Thanksgiving | US
2019-11-28 00:00:00 | Thanksgiving | US
2020-11-26 00:00:00 | Thanksgiving | US
2014-11-11 00:00:00 | Veterans Day | US
2015-11-11 00:00:00 | Veterans Day | US
2016-11-11 00:00:00 | Veterans Day | US
2017-11-11 00:00:00 | Veterans Day | US
2018-11-11 00:00:00 | Veterans Day | US
2019-11-11 00:00:00 | Veterans Day | US
2020-11-11 00:00:00 | Veterans Day | US
2014-12-26 00:00:00 | Boxing Day | UK
2015-12-26 00:00:00 | Boxing Day | UK
2016-12-26 00:00:00 | Boxing Day | UK
2017-12-26 00:00:00 | Boxing Day | UK
2018-12-26 00:00:00 | Boxing Day | UK
2019-12-26 00:00:00 | Boxing Day | UK
2020-12-26 00:00:00 | Boxing Day | UK
2014-04-18 00:00:00 | Good Friday | UK
2015-04-03 00:00:00 | Good Friday | UK
2016-03-25 00:00:00 | Good Friday | UK
2017-04-14 00:00:00 | Good Friday | UK
2018-03-30 00:00:00 | Good Friday | UK
2019-04-19 00:00:00 | Good Friday | UK
2020-04-10 00:00:00 | Good Friday | UK
2014-04-20 00:00:00 | Easter Monday | UK
2015-04-05 00:00:00 | Easter Monday | UK
2016-03-27 00:00:00 | Easter Monday | UK
2017-04-16 00:00:00 | Easter Monday | UK
2018-04-01 00:00:00 | Easter Monday | UK
2019-04-21 00:00:00 | Easter Monday | UK
2020-04-12 00:00:00 | Easter Monday | UK
2014-03-05 00:00:00 | Early May Bank Holiday | UK
2015-03-04 00:00:00 | Early May Bank Holiday | UK
2016-03-02 00:00:00 | Early May Bank Holiday | UK
2017-03-01 00:00:00 | Early May Bank Holiday | UK
2018-03-07 00:00:00 | Early May Bank Holiday | UK
2019-03-06 00:00:00 | Early May Bank Holiday | UK
2020-03-04 00:00:00 | Early May Bank Holiday | UK
2014-05-26 00:00:00 | Spring Bank Holiday | UK
2015-05-25 00:00:00 | Spring Bank Holiday | UK
2016-05-30 00:00:00 | Spring Bank Holiday | UK
2017-05-29 00:00:00 | Spring Bank Holiday | UK
2018-05-28 00:00:00 | Spring Bank Holiday | UK
2019-05-27 00:00:00 | Spring Bank Holiday | UK
2020-05-25 00:00:00 | Spring Bank Holiday | UK
2014-08-25 00:00:00 | Summer Bank Holiday | UK
2015-08-31 00:00:00 | Summer Bank Holiday | UK
2016-08-29 00:00:00 | Summer Bank Holiday | UK
2017-08-28 00:00:00 | Summer Bank Holiday | UK
2018-08-27 00:00:00 | Summer Bank Holiday | UK
2019-08-26 00:00:00 | Summer Bank Holiday | UK
2020-08-31 00:00:00 | Summer Bank Holiday | UK