Count working days in 2027 in the United Kingdom

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
working days = weekdays - bank holidays that fall on weekdays
2027, England and Wales: 261 - 8 = 253

2027 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

DateDayBank holiday
1 January 2027FridayNew Year's Day
26 March 2027FridayGood Friday
29 March 2027MondayEaster Monday
3 May 2027MondayEarly May bank holiday
31 May 2027MondaySpring bank holiday
30 August 2027MondaySummer bank holiday
27 December 2027MondayChristmas Day (substitute day)
28 December 2027TuesdayBoxing Day (substitute day)

UK bank holidays 2027 lists all three regions with their sources.

Working days by month, England and Wales

MonthWeekdaysBank holidaysWorking days
January21120
February20020
March23221
April22022
May21219
June22022
July22022
August22121
September22022
October21021
November22022
December23221
20272618253

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

RegionBank holidays on weekdaysWorking days in 2027
England and Wales8253
Scotland9252
Northern Ireland10251

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")
  1. Get a Sheets key Create one under Google Sheets keys on Team and keys in your dashboard.
  2. Put the key in Replace YOUR_SHEETS_KEY in the formula with your key.
  3. 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:

England and Wales, all of 2027
=NETWORKDAYS(DATE(2027,1,1), DATE(2027,12,31), FILTER(Holidays!A2:A40, ISNUMBER(SEARCH("GB-ENG", Holidays!E2:E40))))
Google Sheets counting 2027 working days from the imported UK bank holiday list: 253 in England and Wales, 252 in Scotland and 251 in Northern Ireland

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

Request
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 .

Next steps