If you’re running a small business in the UK, knowing how many working days are in a month is more than just a trivia fact—it’s essential for scheduling, payroll, and ensuring your team stays on track. Whether you’re calculating deadlines or managing staff leave, understanding the distribution of working days throughout the year is key.
A working day typically refers to Monday through Friday, excluding weekends and public holidays. The exact number of working days in a month depends on these factors:
Working Days in the UK for 2025
England:
Wales:
Scotland:
Northern Ireland:
Why Is Knowing Working Days Important?
Small business owners can benefit greatly from understanding working days:
Frequently Asked Questions (FAQs)
1. How many working days are in a month on average?
Typically, you can expect between 20 and 23 working days in a month, depending on public holidays and weekends.
2. Are Saturdays considered working days in the UK?
No, Saturdays are usually not counted as working days unless your business operates on weekends, like in retail or hospitality sectors.
3. What happens if a public holiday falls on a weekend?
If a UK public holiday falls on a weekend, a substitute bank holiday is often observed on the following Monday.
4. Do part-time employees have the same number of working days?
No, part-time working days vary based on individual contracts. Employers typically prorate holidays and leave entitlements.
5. How do working days differ across UK regions?
While England and Wales share the same bank holidays, Scotland and Northern Ireland have additional holidays like St. Andrew’s Day and St. Patrick’s Day.
6. Can flexible workers have different working days?
Yes, employees with flexible or zero-hours contracts may have varying working days.
7. How do leap years affect working days?
Leap years add an extra day in February, but since February 29 can fall on a weekend, it doesn’t always result in an extra working day.
How to Calculate Working Days (Step-by-Step Guide)
If you prefer to do the math manually:
Example:
For May 2025 in England:
How to Calculate Working Days Using Excel
The NETWORKDAYS
function in Excel (or Google Sheets) calculates the number of working days between two dates, excluding weekends (Saturday and Sunday) and optionally any holidays you specify.
=NETWORKDAYS(start_date, end_date, [holidays])
start_date
: The start of the date range.end_date
: The end of the date range.[holidays]
(optional): A range of dates to be excluded from the working days count (e.g., public holidays).Example 1: Basic Usage
=NETWORKDAYS("2024-02-01", "2024-02-28")
This counts all working days in February 2024, excluding weekends.
Example 2: With Holidays
Assume holidays are listed in cells C2:C4
(e.g., 2024-02-14
, 2024-02-19
, 2024-02-26
):
=NETWORKDAYS("2024-02-01", "2024-02-28", C2:C4)
This calculates working days in February 2024, excluding weekends and the holidays in C2:C4
.
Quick Tips:
start_date
and end_date
are included in the calculation.NETWORKDAYS.INTL
where you can define which days are weekends.
Struggling to Keep Track of Holidays and Working Days?
Simplify your absence and holiday tracking with TimeOff.Management.
✅ Manage leave requests effortlessly
✅ Get accurate calculations
✅ Automate reminders and approvals
👉 Try TimeOff.Management Today – Save time, reduce errors, and focus on growing your business!