horizon-schedule-bank-holidays.md (1763B)
1 --- 2 title: "Gamma Horizon Bank Holiday Schedules" 3 date: 2025-11-07T16:31:00 4 lastmod: 2026-01-23T16:03:00 5 tags: ["Snippets", "Work"] 6 --- 7 8 It's not too often that I need to bulk import bank holidays into a Horizon account, however when I do I like to do it as simply as possible. What I've compiled below are the bank holiday dates for the UK next couple of years, compiled from [this goverment resource](https://www.gov.uk/bank-holidays). 9 10 What I like to do is copy the first column, alt-tab to enter it as the name, then alt-tab back, copy the second column, alt-tab back to Horizon then tab x3, paste, tab x2, paste before finally clicking Create. You can get quite good at this with a bit of practice. 11 12 ``` 13 BH 2026-01-01 01/01/2026 14 BH 2026-04-03 03/04/2026 15 BH 2026-04-06 06/04/2026 16 BH 2026-05-04 04/05/2026 17 BH 2026-05-25 25/05/2026 18 BH 2026-08-31 31/08/2026 19 BH 2026-12-25 25/12/2026 20 BH 2026-12-28 28/12/2026 21 22 BH 2027-01-01 01/01/2027 23 BH 2027-03-26 26/03/2027 24 BH 2027-03-29 29/03/2027 25 BH 2027-05-03 03/05/2027 26 BH 2027-05-31 31/05/2027 27 BH 2027-08-30 30/08/2027 28 BH 2027-12-27 27/12/2027 29 BH 2027-12-28 28/12/2027 30 31 BH 2028-01-03 03/01/2028 32 BH 2028-04-14 14/04/2028 33 BH 2028-04-17 17/04/2028 34 BH 2028-05-01 01/05/2028 35 BH 2028-05-29 29/05/2028 36 BH 2028-08-28 28/08/2028 37 BH 2028-12-25 25/12/2028 38 BH 2028-12-26 26/12/2028 39 ``` 40 41 One easily solved issue you may come across is the date selector window remaining open as you've pasted in a date versus clicking one. This can be fixed by removing the element entirely by blocking the following rule: 42 ``` 43 ##.ui-corner-all.ui-helper-clearfix.ui-widget-content.ui-widget.ui-datepicker 44 ``` 45 46 Another solution entirely is to use Contact call routing, but you've gotta pay for that improvement. 47 48 49 * **Edit 2026-01-23:** Added 2028 dates