Working Days Calculator, Explained

After reading this you can count the exact number of business days between two dates, add a run of working days to a start date, and adjust both correctly for your own weekends and holidays.

A working days calculator answers two related questions. The first is a count: how many business days lie between a start date and an end date. The second is a shift: what date do you reach after adding a fixed number of business days to a start date. Both questions skip weekends and any holidays you supply.

Here is the hook. A project starts on Monday, 6 January 2025 and the plan allows 10 working days. A naive answer adds 10 calendar days and lands on Thursday, 16 January. The correct answer skips the two weekends inside that stretch and lands on Friday, 17 January. Two extra days appear from nowhere unless you count business days directly.

What the tool counts, and what it does not

The counting mode reports how many working days fall in a date range. The result is a whole number: you cannot have half a working day here. What varies is whether the two endpoints themselves are counted.

This tool counts the days strictly between the two dates in a half-open way: it includes the start date and excludes the end date, or the reverse, depending on the convention you choose. Payroll and SLA calculations often want the start day counted and the finish day counted too, which is one day more. Always know which convention you are using before you trust a number.

Working day

A calendar day that is neither a weekend day (as you define weekends) nor a listed holiday.

Weekend day

Any weekday you mark as non-working. The default is Saturday and Sunday, but some calendars use Friday and Saturday.

Holiday

A specific date you supply that is treated as non-working even if it lands on a weekday.

When to use it, and when not to

Use business day counting when the answer depends on office availability: contract deadlines, shipping estimates, notice periods, invoice due dates, and staffing plans. A "net 30 business days" invoice term is meaningless if you count calendar days.

Do not use it when the underlying process runs every day. Interest accrual, medical dosing intervals, and age in days all run on calendar time. For those, count raw days with the Date Difference Calculator instead. For exact age in years and months, use the Age Calculator.

The formula and the intuition behind it

Counting business days in a range does not require checking every day one by one, though that is the safest method for small ranges. For a range with no holidays, the arithmetic is quick. Let D be the total number of calendar days in the half-open interval, and let each week contribute a fixed number of working days.

Here W is the working day count, w_{\text{full}} is the number of weekend days per week (2 in the common case), n_w is the number of whole weeks in the interval, and r is the number of weekend days in the leftover partial week. You then subtract any holidays that land on a working day.

The intuition is simpler than the symbols. Every full 7-day week removes exactly the same fixed count of weekend days, so most of the work is a multiplication. Only the ragged ends of the interval need day-by-day inspection. This tool inspects every day, which is slower but immune to off-by-one slips at the edges.

A worked example using the demo data

The same date pair read as a count works in reverse. From Monday 6 January up to but not including Monday 20 January, the interval holds 14 calendar days. Two full weeks contribute 4 weekend days, so 14 - 4 = 10 working days, matching the step count above.

Watch how weekends and holidays reshape the count

Reading and interpreting the result

Two numbers deserve attention when you read a working days result. The first is the count itself. The second is the implied calendar span, which the shift mode gives you as a finish date. Compare the two to sanity-check the work.

A useful ratio is working days to calendar days. With a standard 2-day weekend and no holidays, roughly 5/7 \approx 0.714 of calendar days are working days over the long run. So a 100 calendar day stretch holds about 71 or 72 working days, drifting by a day or two depending on which weekday the stretch begins. If your result strays far from that ratio, you probably have a weekend or holiday setting wrong.

The low and high columns differ because a partial week can start on any weekday. Thirty days beginning on a Saturday captures fewer working days than thirty days beginning on a Monday.

Common mistakes

The endpoint convention causes the most confusion. Counting both endpoints gives one more than counting one endpoint, and both are correct for different purposes. Decide first, then read the result.

Holiday list format is the next trap. If a listed holiday does not match the date format the tool expects, it is silently ignored and your count runs one day high. After pasting a list, confirm the count dropped by the number of holidays you expect that actually fall on working days.

The last trap is the wrong weekend. In much of the Gulf region the weekend is Friday and Saturday, not Saturday and Sunday. A run planned with the wrong weekend can be off by one working day per week, which compounds fast: over eight weeks that is eight working days of error.

Related tools

For plain calendar-day arithmetic without weekend skipping, use the Date Difference Calculator. To find where a date sits in the year, the Week Number Lookup gives the ISO week number and day-of-year, which pairs well with weekly reporting cycles.

Related tools

Age Calculator

Exact age in years, months and days, plus next birthday.

Date Difference Calculator

Days between dates, or add and subtract time from a date.

Week Number Lookup

ISO week number and day-of-year for any date.

Countdown Generator

Live countdown to any date, with a shareable link.

Countdown Timer

Set a duration and count down to zero with an alarm.

Meeting Planner

Find meeting hours that work across multiple time zones.