England and Wales have 253 working days in 2027: 261 weekdays minus 8 bank holidays. Scotland has 252 and Northern Ireland 251, because each has its own bank holidays. New here? Create a free account and you get a Sheets key and starting credit to try this.
The count
working days = weekdays - bank holidays that fall on weekdays
2027, England and Wales: 261 - 8 = 2532027 has 365 days and starts on a Friday, so it has 261 weekdays, Monday to Friday. Every bank holiday in 2027 falls on a weekday, because Christmas Day and Boxing Day land on a Saturday and a Sunday and move to Monday 27 and Tuesday 28 December. Count business days between two dates explains the method for any range.
Bank holidays in 2027, England and Wales
| Date | Day | Bank holiday |
|---|---|---|
| 1 January 2027 | Friday | New Year's Day |
| 26 March 2027 | Friday | Good Friday |
| 29 March 2027 | Monday | Easter Monday |
| 3 May 2027 | Monday | Early May bank holiday |
| 31 May 2027 | Monday | Spring bank holiday |
| 30 August 2027 | Monday | Summer bank holiday |
| 27 December 2027 | Monday | Christmas Day (substitute day) |
| 28 December 2027 | Tuesday | Boxing Day (substitute day) |
UK bank holidays 2027 lists all three regions with their sources.
Working days by month, England and Wales
| Month | Weekdays | Bank holidays | Working days |
|---|---|---|---|
| January | 21 | 1 | 20 |
| February | 20 | 0 | 20 |
| March | 23 | 2 | 21 |
| April | 22 | 0 | 22 |
| May | 21 | 2 | 19 |
| June | 22 | 0 | 22 |
| July | 22 | 0 | 22 |
| August | 22 | 1 | 21 |
| September | 22 | 0 | 22 |
| October | 21 | 0 | 21 |
| November | 22 | 0 | 22 |
| December | 23 | 2 | 21 |
| 2027 | 261 | 8 | 253 |
May has the fewest working days, 19, because of the early May and spring bank holidays. April, June, July, September and November have the most, 22 each.
Scotland and Northern Ireland
| Region | Bank holidays on weekdays | Working days in 2027 |
|---|---|---|
| England and Wales | 8 | 253 |
| Scotland | 9 | 252 |
| Northern Ireland | 10 | 251 |
Scotland adds 2 January (moved to Monday 4 January), St Andrew's Day on Tuesday 30 November, and holds its summer bank holiday on 2 August instead of 30 August. It has no Easter Monday. Northern Ireland has the England and Wales list plus St Patrick's Day on Wednesday 17 March and the Battle of the Boyne on Monday 12 July.
Count it in Google Sheets
Load the 2027 UK bank holidays into a tab named Holidays:
=IMPORTDATA("https://api.narwhalapi.com/v1/calendars/holidays/GBR/2027?format=csv&key=YOUR_SHEETS_KEY")- Get a Sheets key Create one under Google Sheets keys on Team and keys in your dashboard.
- Put the key in Replace
YOUR_SHEETS_KEYin the formula with your key. - Paste it Click A1 in an empty tab named Holidays, paste and press Enter. The first time in a spreadsheet, click Allow access.
The list has one row per region, and column E holds the region codes. Count in another tab, keeping only the England and Wales rows. This gives 253:
=NETWORKDAYS(DATE(2027,1,1), DATE(2027,12,31), FILTER(Holidays!A2:A40, ISNUMBER(SEARCH("GB-ENG", Holidays!E2:E40))))
Use GB-SCT for Scotland (252) or GB-NIR for Northern Ireland (251). For one month or any other range, change the two dates.
Get it with the API
curl https://api.narwhalapi.com/v1/calendars/holidays/GBR/2027 \
-H "Authorization: Bearer $NARWHAL_API_KEY"Each holiday has date, name, scope, subdivision_codes and observed. Keep the rows whose subdivision_codes include your region, then count the weekdays that are not on the list. The Python script in Count business days between two dates does the counting.
Does a bank holiday on a weekend reduce the count?
No. A weekend day is not a working day anyway. When a bank holiday falls on a weekend the UK gives a substitute weekday instead, and that day is the one subtracted. In 2027 that happens to Christmas Day and Boxing Day, and to 2 January in Scotland.
Is every bank holiday a day off?
Banks and most offices close, but shops, hospitals and many other employers work as usual. The count here is the common office calendar. If your contract or business has other closing days, add them to the holiday column.
Published .