Dates formula

Working Days Between Two Dates

Working days are the days on which work can actually be done: the weekdays in a period, less public holidays and any leave. The count is used for handovers, project plans, day-rate invoices and leave balances. Unlike a plain date difference, it normally includes both the first and the last day.

Formula

working days = weekdays − holidays and leave on weekdays, where weekdays = 5 × whole weeks + the weekdays among the leftover days, and the period runs from the first day to the last day with both counted

first day
the first date of the period, counted if it is a Monday to Friday
last day
the final date of the period, counted in the same way
calendar days
last day − first day + 1, every date in the period
whole weeks
calendar days ÷ 7, rounded down; each contains exactly 5 weekdays
leftover days
the 0 to 6 days remaining after the whole weeks, beginning on the weekday of the first day
weekdays
all the Mondays to Fridays in the period
holidays and leave
public holidays and days off that fall on a Monday to Friday inside the period
working days
weekdays minus holidays and leave

Working Days Calculator Notice Period Calculator

What it means

The count has two stages, and only the first is arithmetic. Any seven consecutive days contain five weekdays and two weekend days, so each whole week in the period contributes 5. The leftover days, never more than six, are checked one by one against the calendar, beginning with the weekday on which the period starts. Adding the two parts gives the weekdays.

Both ends are counted because the question is nearly always "on how many days can I work?", and you can work on the first day and on the last. That makes this count one day more generous than a date difference: Monday to Friday of one week is 4 days apart but 5 working days. If you take a day count from somewhere else, check which convention produced it before you combine the two.

Weekdays are not yet working days. Public holidays remove days, and they differ by country, by region and from year to year, so no formula can supply them: look them up in an official calendar for your location and count those that land on a Monday to Friday. A holiday that falls on a weekend removes nothing unless a substitute weekday is given. Booked leave, employer closure days and training days come off in the same way if you want the days you will really spend on the work.

The formula also assumes a Monday-to-Friday week. Where the weekend falls on other days, or you work shifts, part-time days or a compressed week, replace the 5 with your own pattern and check the leftover days against your rota. A contract or regulation that sets a period in "working days" or "business days" may also define the term itself, including whether the first day counts, and that definition overrides any general count.

Other forms

Calendar days in the period, both ends counted
calendar days = last day − first day + 1
Weekend days in the period
weekend days = calendar days − weekdays
Holidays and leave that still leave enough working days
holidays and leave = weekdays − working days needed
Rough estimate of weekdays in a long period
weekdays ≈ calendar days × 5 ÷ 7

Worked example

A project starts on Thursday 12 November 2026 and must be delivered on Tuesday 19 January 2027. Where you live, 3 public holidays fall on weekdays in that period, and you have booked 2 days of leave.

  1. Calendar days, both ends counted: 19 in November (the 12th to the 30th) + 31 in December + 19 in January = 69
  2. Whole weeks: 69 ÷ 7 = 9 with 6 days left over, because 9 × 7 = 63
  3. Weekdays in the whole weeks: 9 × 5 = 45
  4. Leftover days, beginning on a Thursday: Thursday, Friday, Saturday, Sunday, Monday, Tuesday, of which 4 are weekdays
  5. Weekdays: 45 + 4 = 49
  6. Weekend days: 69 − 49 = 20
  7. Working days: 49 − 3 public holidays − 2 leave days = 44

Result: The period holds 69 calendar days and 49 weekdays, and after 5 days of holidays and leave you have 44 working days in which to deliver the project.

Where it is used

You resign on Monday 9 November 2026 with six weeks of notice that starts the next day, so your last day is Monday 21 December 2026. From 10 November to 21 December is 42 calendar days, which is exactly 6 whole weeks and therefore 6 × 5 = 30 weekdays. You have agreed to take 4 days of leave before you go, which leaves 30 − 4 = 26 working days for the handover. Dividing your open tasks across 26 days, not across "six weeks", gives your manager a realistic plan. How notice and unused leave are treated depends on your contract and on local rules, so confirm both in writing.

Common mistakes

  • Using a plain date difference for the calendar days, which leaves out the first day and can drop a weekday from the count.
  • Multiplying calendar days by 5 ÷ 7 and rounding, which is only an estimate and can be a day or two out over a short period.
  • Subtracting a public holiday that falls on a Saturday or Sunday, which was never in the weekday count to begin with.
  • Relying on a holiday list for the wrong country, region or year, since public holidays differ between all three.
  • Reading "working days" in a contract or policy as Monday to Friday without checking how that document defines the term and whether it counts the first day.

Questions and answers

What is the difference between weekdays, working days and business days?

Weekdays are Mondays to Fridays. Working days are the weekdays left after public holidays, and often leave, are removed. "Business days" usually means weekdays that are not public holidays, but the term has no single definition, so a contract, a bank and a courier may each count it differently.

How many working days are there in a month?

A month contains 20 to 23 weekdays, depending on its length and on the weekday it begins with. Public holidays and leave then reduce that figure. For a specific month, enter its first and last dates in the Working Days Calculator and subtract your own holidays.

Does a half day count as a working day?

The formula counts whole days only. If you have half days of leave or a part-time pattern, add the halves together and subtract the total, or count in hours instead. Say which unit you used when you pass the figure to anyone else.

How do I find the date a given number of working days away?

Count forward along the calendar, skipping Saturdays, Sundays and any public holidays, until you have used up the number. As a shortcut, every 5 working days is one calendar week before holidays are allowed for. Check first whether the starting day itself is meant to count.