NETWORKDAYS
Date/Time Functions:
Function: NETWORKDAYS() - Returns the number of whole working days between start_date and end_date. Working days exclude weekends and any dates identified in holidays.
UK Public Holidays
+------------+-------------------------------+
| J | K |
+---+------------+-------------------------------+
| 1 | 2022-01-03 | New Year |
| 2 | 2022-04-15 | Good Friday |
| 3 | 2022-04-18 | Easter Monday |
| 4 | 2022-05-02 | Early May Bank Holiday |
| 5 | 2022-06-02 | Spring Bank Holiday |
| 6 | 2022-06-03 | Platinum Jubilee Bank Holiday |
| 7 | 2022-08-29 | Summer Bank Holiday |
| 8 | 2022-12-26 | Boxing Day |
| 9 | 2022-12-27 | Christmas Day |
+---+------------+-------------------------------+
Between 2022-01-01 and 2022-01-31 is 21 working days; 20 excluding public holidays
Between 2022-01-01 and 2022-02-28 is 41 working days; 40 excluding public holidays
Between 2022-01-01 and 2022-03-31 is 64 working days; 63 excluding public holidays
Between 2022-01-01 and 2022-04-30 is 85 working days; 82 excluding public holidays
Between 2022-01-01 and 2022-05-31 is 107 working days; 103 excluding public holidays
Between 2022-01-01 and 2022-06-30 is 129 working days; 123 excluding public holidays
Between 2022-01-01 and 2022-07-31 is 150 working days; 144 excluding public holidays
Between 2022-01-01 and 2022-08-31 is 173 working days; 166 excluding public holidays
Between 2022-01-01 and 2022-09-30 is 195 working days; 188 excluding public holidays
Between 2022-01-01 and 2022-10-31 is 216 working days; 209 excluding public holidays
Between 2022-01-01 and 2022-11-30 is 238 working days; 231 excluding public holidays
Between 2022-01-01 and 2022-12-31 is 260 working days; 251 excluding public holidays