WORKDAY
Date/Time Functions:
Function: WORKDAY() - Returns a number that represents a date that is the indicated number of working days before or after a starting date. Working days exclude weekends and any dates identified as 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 |
+---+------------+-------------------------------+
10 workdays from 2022-01-01 is 2022-01-14; 2022-01-17 with public holidays
20 workdays from 2022-01-01 is 2022-01-28; 2022-01-31 with public holidays
30 workdays from 2022-01-01 is 2022-02-11; 2022-02-14 with public holidays
40 workdays from 2022-01-01 is 2022-02-25; 2022-02-28 with public holidays
50 workdays from 2022-01-01 is 2022-03-11; 2022-03-14 with public holidays
60 workdays from 2022-01-01 is 2022-03-25; 2022-03-28 with public holidays
70 workdays from 2022-01-01 is 2022-04-08; 2022-04-11 with public holidays
80 workdays from 2022-01-01 is 2022-04-22; 2022-04-27 with public holidays
90 workdays from 2022-01-01 is 2022-05-06; 2022-05-12 with public holidays
100 workdays from 2022-01-01 is 2022-05-20; 2022-05-26 with public holidays
110 workdays from 2022-01-01 is 2022-06-03; 2022-06-13 with public holidays
120 workdays from 2022-01-01 is 2022-06-17; 2022-06-27 with public holidays
130 workdays from 2022-01-01 is 2022-07-01; 2022-07-11 with public holidays
140 workdays from 2022-01-01 is 2022-07-15; 2022-07-25 with public holidays
150 workdays from 2022-01-01 is 2022-07-29; 2022-08-08 with public holidays
160 workdays from 2022-01-01 is 2022-08-12; 2022-08-22 with public holidays
170 workdays from 2022-01-01 is 2022-08-26; 2022-09-06 with public holidays
180 workdays from 2022-01-01 is 2022-09-09; 2022-09-20 with public holidays
190 workdays from 2022-01-01 is 2022-09-23; 2022-10-04 with public holidays
200 workdays from 2022-01-01 is 2022-10-07; 2022-10-18 with public holidays
210 workdays from 2022-01-01 is 2022-10-21; 2022-11-01 with public holidays
220 workdays from 2022-01-01 is 2022-11-04; 2022-11-15 with public holidays
230 workdays from 2022-01-01 is 2022-11-18; 2022-11-29 with public holidays
240 workdays from 2022-01-01 is 2022-12-02; 2022-12-13 with public holidays
250 workdays from 2022-01-01 is 2022-12-16; 2022-12-29 with public holidays
260 workdays from 2022-01-01 is 2022-12-30; 2023-01-12 with public holidays
270 workdays from 2022-01-01 is 2023-01-13; 2023-01-26 with public holidays
280 workdays from 2022-01-01 is 2023-01-27; 2023-02-09 with public holidays
290 workdays from 2022-01-01 is 2023-02-10; 2023-02-23 with public holidays
300 workdays from 2022-01-01 is 2023-02-24; 2023-03-09 with public holidays
310 workdays from 2022-01-01 is 2023-03-10; 2023-03-23 with public holidays
320 workdays from 2022-01-01 is 2023-03-24; 2023-04-06 with public holidays
330 workdays from 2022-01-01 is 2023-04-07; 2023-04-20 with public holidays
340 workdays from 2022-01-01 is 2023-04-21; 2023-05-04 with public holidays
350 workdays from 2022-01-01 is 2023-05-05; 2023-05-18 with public holidays
360 workdays from 2022-01-01 is 2023-05-19; 2023-06-01 with public holidays