Workday Calculator Explained
A workday calculator counts Monday-to-Friday days between two dates, optionally skipping public holidays. It looks like simple arithmetic, but the algorithm behind it has to handle inclusive endpoints, reversed inputs, leap years, and the fact that "business day" means different things to a court, a payroll team, and a bank. Here is the math, the standards, and the edge cases.
What a workday calculator actually counts
A workday calculator answers one question that a normal calendar refuses to: how many Monday-to-Friday days lie between two dates, ignoring the weekends in between. That sounds trivial until you try to compute it for a contract deadline 73 days out, with two public holidays falling inside the range, and a requirement to include both endpoints. The shortcut everyone reaches for — "divide by 7, multiply by 5" — only works when the range starts and ends on the same weekday, which is rarely the case.
Excel built NETWORKDAYS into version 4.0 in 1992 precisely because the manual count is error-prone, and the algorithm has not changed since. The Calc Dragon workday calculator uses the same algorithm: full weeks contribute exactly 5 workdays each, the remainder is walked one day at a time starting from the input weekday, then any supplied holidays are subtracted. The result matches NETWORKDAYS to the integer, and matches the timeanddate.com workday counter for every input pair we have tested. This article walks through how that algorithm works, what counts as a "business day" in legal and payroll contexts (the answer is not the same in every jurisdiction), and the edge cases worth understanding before you trust an output to a statutory deadline.
The algorithm: full weeks plus remainder
Given a start date a and an end date b (with a ≤ b), the total calendar-day span inclusive is (b − a) ÷ 86,400,000 ms + 1. Call that total T. The clever step is to split T into fullWeeks = ⌊T ÷ 7⌋ and remainder = T − 7 × fullWeeks. Each full week — any 7 consecutive days — contains exactly 5 weekdays and 2 weekend days, regardless of which day of the week you started on. So the weekday count from the full-weeks portion is fullWeeks × 5 with no ambiguity.
The remainder is 0 to 6 days, and how many of those are weekdays depends on which day of the week the count starts on. The calculator looks at the start date's day-of-week index (0 for Sunday, 1 for Monday, ..., 6 for Saturday) and walks the remainder one position at a time, incrementing a counter whenever the position lands on 1–5. That gives the workdays-before-holidays figure exactly. Subtracting the supplied holiday count (capped at the workday total so the result cannot go negative) gives the net business-day answer the workday calculator displays.
Two things make this algorithm fast and robust. First, it is O(1) in the size of the range — a 50-year span and a 2-week span both take the same handful of operations. Second, it never iterates over individual dates, so calendar irregularities like leap years and DST transitions cannot break it: the only place dates appear is in computing the total day span and the starting day-of-week, both of which are single calls.
Worked example: workdays in Q1 2026
Suppose you want the working days in the first quarter of 2026. Start = Thursday 1 January 2026, end = Tuesday 31 March 2026.
- Total calendar days inclusive: 31 (Jan) + 28 (Feb) + 31 (Mar) = 90 days.
- Full weeks: ⌊90 ÷ 7⌋ = 12, contributing 12 × 5 = 60 weekdays.
- Remainder: 90 − 84 = 6 days, starting on Thursday (day index 4). The 6 positions land on Thu, Fri, Sat, Sun, Mon, Tue — 4 of those are weekdays.
- Weekdays before holidays: 60 + 4 = 64.
- UK public holidays in Q1 2026 falling on a weekday: New Year's Day (Thu 1 Jan), Good Friday (Fri 3 Apr — outside the range), Easter Monday (Mon 6 Apr — outside the range). Inside the range: only New Year's Day. Enter 1.
- Net workdays: 64 − 1 = 63.
Pop those inputs into the workday calculator and the primary output is 63 with the breakdown above. Cross-check against Excel: =NETWORKDAYS("2026-01-01","2026-03-31",{"2026-01-01"}) returns 63. For a US federal-holiday version, the weekday holidays inside Q1 2026 are New Year's Day (1 Jan), Martin Luther King Jr. Day (Mon 19 Jan), Presidents' Day (Mon 16 Feb) — three weekday holidays, net workdays = 64 − 3 = 61. Same algorithm, different holiday count.
"Business day" means different things in different rules
The arithmetic is universal; the legal definition is not. Before relying on any workday calculator output for a regulated deadline, check what the rule actually defines a business day as.
UK: Civil Procedure Rules and Banking Days Act
Under the UK Civil Procedure Rules (CPR) Rule 2.8, "business day" means any day except a Saturday, Sunday, Christmas Day, Good Friday, or a bank holiday under the Banking and Financial Dealings Act 1971. That gives the standard UK workday calendar most people expect: Mon–Fri excluding eight statutory bank holidays in England and Wales (Scotland and Northern Ireland have slightly different lists). For periods of 5 days or less, the CPR uses "clear days" instead — the day the period is computed from and the day it ends are both excluded — which is more restrictive than the inclusive default in the workday calculator. Always read the specific rule.
US: federal versus state versus banking
US federal court rules (Federal Rules of Civil Procedure Rule 6) define "legal holiday" as the ten federal holidays listed in 5 USC § 6103 plus any day the court is closed. State courts follow state statutes that usually mirror but sometimes extend the federal list (California, for example, adds Cesar Chavez Day). US banking rules under Regulation CC define "business day" as Monday through Friday excluding federal holidays, and "banking day" as a business day on which a particular bank is open for substantially all banking functions — a narrower definition that can change bank by bank. For a consumer-facing US deadline, the federal-holiday workday count is the right starting point; for inter-bank settlement, check the specific bank's calendar.
International: ISO 8601 and the rest of the world
ISO 8601 (the date-format standard) defines the working week as Monday to Friday and the weekend as Saturday and Sunday, which is what the calculator and Excel both use. Most of Europe, the Americas, and Commonwealth countries follow that convention. Exceptions: Saudi Arabia, the UAE, and Kuwait historically used Sunday–Thursday as the working week (the UAE moved to a 4.5-day Mon–Fri week in 2022, with Friday afternoon, Saturday and Sunday off); Iran uses Saturday– Wednesday, with Thursday and Friday as weekend; Israel uses Sunday– Thursday with Friday–Saturday as weekend. A standard workday calculator will give the wrong answer for any of those — use Excel's NETWORKDAYS.INTL with a custom weekend mask, or a regional-specific calculator.
Edge cases the algorithm gets right
The same date twice
If start = end and that date is a weekday, the count is 1. This matches the inclusive convention and is what every well-tested implementation returns. If the date is a Saturday or Sunday, the count is 0 — the only day in the range is a weekend day, and weekends are never workdays. This is a small but commonly-missed edge case; early naive implementations of NETWORKDAYS in some libraries used to return 0 for any single-day range, which is wrong.
Reversed inputs
If the end date is before the start date, the workday calculator swaps them internally and returns the workday count for the absolute range. The result is the same positive integer either way. This is consistent with Excel NETWORKDAYS (also returns a non-negative integer) and with timeanddate.com. It matters because date-entry mistakes are common — the calculator surfaces a "reversed" note in the explanation so you can catch the swap rather than silently trusting the number.
Leap years
The calculator handles leap years automatically because it works in whole calendar days. A range that crosses 29 February in a leap year picks up that extra day — which becomes an extra workday if 29 February falls on a Monday to Friday (2028: Tuesday; 2032: Sunday; 2036: Friday; 2040: Wednesday), and nothing if it falls on a Saturday or Sunday. The algorithm does not need a special case for this — it falls out of the day-count subtraction at the start.
Holidays exceeding workdays
If you enter more holidays than there are weekdays in the range, the result is capped at zero rather than going negative. This is a defensive measure — it stops accidental typos (entering "30" instead of "3" for holidays in a 2-week range) from producing nonsense — and matches the behaviour of Excel NETWORKDAYS, which returns a negative number in that case but where negative business-day counts are meaningless. Calc Dragon prefers a zero output over a confusing negative one.
Common mistakes
Counting calendar days when you need business days
"30 days from today" rarely means 30 calendar days when the context is a court order, payroll cycle, or supplier SLA — it usually means 30 business days, which in the UK with no holidays is 6 weeks, and with holidays can be more. The workday calculator gives the business-day count; the days between dates calculator gives the calendar-day count. Mixing them up costs real money in late-delivery clauses. Always check which one your contract specifies.
Counting holidays that fall on a weekend
US Independence Day (4 July) in 2026 falls on a Saturday; UK Christmas Day (25 December) in 2027 falls on a Saturday. Both countries observe substitute days for the workforce (the Friday or Monday respectively), but the original calendar date is already excluded as a weekend day in any workday calculation. Count the substitute weekday, not both — counting both will double-subtract. The official gov.uk/bank-holidays page and the US Office of Personnel Management opm.gov holiday list publish the observed-day calendar, which is what you want.
Assuming "5 working days" means the same thing everywhere
UK Royal Mail "next-day delivery" means the next working day after posting, where working day means Mon–Fri. UK government "5 working days" almost always means 5 business days inclusive of the day of receipt under standard interpretation. UK court CPR "5 clear days" excludes both endpoints. US federal court "5 business days" follows FRCP Rule 6 and excludes the day the event occurs. A workday calculator gives the inclusive count; whether you add or subtract a day depends on the rule, and there is no universal default.
Forgetting that some regions move public holidays
UK bank holidays that fall on a weekend move to the next Monday by Royal Proclamation. US federal holidays falling on a Saturday are observed the preceding Friday; falling on a Sunday, the following Monday. When you count holidays inside a range, count the observed date — the day people actually have off — not the original calendar date. Most published holiday lists give the observed date by default for exactly this reason.
When the workday calculator is the wrong tool
The workday calculator handles Mon–Fri minus weekends minus a holiday count. Four cases where another tool fits better:
Hours, not days. If you need "8 working hours from now", that is a time-of-day problem, not a date problem. Use the time duration calculator or a project-management tool that understands working-hour calendars.
Calendar elapsed time. "How old will my child be on their next birthday?" is a calendar-day question, not a business-day one. The age calculator gives years, months, and days; the days between dates calculator gives total elapsed days including weekends.
Adding business days to a starting date. "What is the date 30 working days from today?" is the inverse of what the workday calculator does — Excel has a separate WORKDAY function for this. The date calculator handles calendar-day addition and subtraction; a workday-aware date adder is on the roadmap.
Industry-specific working weeks. Retail with Sunday trading, hospitals with 7-day rotas, broadcasting with weekend-heavy schedules — none of these match the Mon–Fri default. For those, a custom calendar tool that lets you mark working days explicitly is the right answer, not a Mon–Fri workday counter.
Where the algorithm and the standards come from
The full-weeks-plus-remainder algorithm appears in early spreadsheet documentation from the late 1980s and was canonicalised in Excel 4.0 (1992) as NETWORKDAYS, then in NETWORKDAYS.INTL (Excel 2010) with custom weekend masks. Modern date libraries — date-fns (differenceInBusinessDays), Luxon, Moment, Python pandas (bdate_range) — all use a direct descendant of the same algorithm. The five-day Monday-to-Friday working week itself is older than the algorithm: it became the common Western standard between 1908 (when a New England spinning mill first adopted it) and 1940 (when the US Fair Labor Standards Act amendment formalised the 40-hour week as Monday–Friday).
The legal frameworks the workday calculator sits inside are codified in: the UK Banking and Financial Dealings Act 1971 (bank holidays); UK Civil Procedure Rules Rule 2.8 (definition of business day and clear days for civil court deadlines); US Code Title 5 Section 6103 (federal holidays); US Federal Rules of Civil Procedure Rule 6 (computing time for federal courts); ISO 8601:2019 (the Mon–Fri working-week standard); and the Banking and Financial Dealings Act 1971 as updated by Royal Proclamation for substitute days. Every output the calculator produces should be compatible with those rules at the integer level — what they will not do is replace reading the specific rule wording for a deadline that matters.
Frequently asked questions
What counts as a workday?
In a workday calculator, a workday is any Monday through Friday. Saturday and Sunday are weekends and are never counted, regardless of public holiday status. This matches the default convention used by Microsoft Excel's NETWORKDAYS function, Google Sheets, most payroll systems, the US Federal Acquisition Regulation definition of "workday", and the UK Civil Procedure Rules definition of "business day" (which adds bank holidays on top). If your jurisdiction or industry uses a different working week — for example a Sunday-to-Thursday week common in parts of the Middle East — a standard workday calculator will not be correct; use a regional variant such as Excel's NETWORKDAYS.INTL with a custom weekend mask.
Are both the start and end dates included in the count?
Yes, the workday calculator uses the inclusive convention: if you enter the same weekday as both start and end, the result is 1 workday. This matches Excel NETWORKDAYS, most payroll systems, and the everyday UK and US legal meaning of "5 working days" (Monday-to-Friday delivery is 5 working days, not 4). The opposite convention — exclusive of the start date — is used by some banking value-date rules and a handful of court orders. If your rule says "5 working days from the date of notice", subtract one from the calculator output to get the exclusive-of-start equivalent.
How is the workday calculator different from Excel NETWORKDAYS?
The arithmetic is identical. Excel NETWORKDAYS(start, end, [holidays]) returns the same integer the calculator does for any well-formed input, because both algorithms count full weeks of 5 weekdays plus a remainder, then subtract the supplied holiday count. The differences are interface and reach: Excel needs a workbook, a fixed holiday list, and the right serial-number date format; the calculator takes plain numeric date parts and a holiday count and works on any device. For one-off questions ("how many workdays until 14 August?"), the calculator is faster; for batch work over a column of date pairs, Excel is the right tool.
How should I handle public holidays?
Count the public holidays that fall on weekdays inside your range, and enter the total in the holidays field. The calculator subtracts that many weekdays from the result. Do not count holidays that fall on a Saturday or Sunday, because those dates are already excluded as weekend days. The calculator does not ship with a built-in holiday list because holidays vary by country, region, and even by employer — a UK calendar includes Christmas Day, Boxing Day, Good Friday, Easter Monday, three May/August bank holidays, and the substitute days for Christmas Day and Boxing Day when they fall on a weekend; a US federal calendar includes ten holidays plus state-specific additions. The official lists are at gov.uk/bank-holidays for the UK and opm.gov for US federal staff.
What if the end date is before the start date?
The calculator treats the range as absolute and returns the same positive workday count regardless of direction. The explanation flags that the input was reversed so you can spot a date-entry mistake without re-running. This matches the behaviour of Excel NETWORKDAYS, which also returns a non-negative number, and the timeanddate.com workday counter. The reversed-input behaviour is useful for "how long ago" questions where the historical date is more naturally placed first.
Does the calculator account for leap years and daylight saving time?
Leap years are handled automatically because the calculator works in whole calendar days, not 365-day windows. A range that crosses 29 February in a leap year picks up that extra calendar day — which becomes an extra workday if 29 February falls on a Monday to Friday, and nothing if it falls on a Saturday or Sunday. Daylight saving has no effect at all. All dates are processed in UTC and counted as whole days, so the one-hour wall-clock shift in spring or autumn never changes which date you are on or how many workdays the range contains.
Can I use this for statutory deadlines like "10 business days to respond"?
Treat the calculator output as a first estimate, then verify against the specific rule wording. Many jurisdictions count business days from the day after notice is received, not the day of receipt — that is a one-day shift from the inclusive default. The UK Civil Procedure Rules use "clear days" for short periods, which excludes both the day of the act and the day of the event. Some courts and regulators define "business day" by reference to a published court calendar that excludes specific judicial holidays not in any national list. Use the calculator to find the candidate date, then check the exact rule, and when in doubt build in a one-day safety margin.
Is the algorithm faster than counting day by day?
Yes, by a factor proportional to the range. A naive day-by-day loop over a 10-year range is 3,653 iterations; the full-weeks-plus-remainder algorithm is one division, one multiplication, and a remainder loop of at most 6 iterations regardless of how long the span is. The calculator runs in microseconds even for ranges spanning centuries. The algorithm dates back to early spreadsheet implementations of NETWORKDAYS in the late 1980s and has been the standard ever since — every modern date library (date-fns, Luxon, Moment, Python pandas business-day offsets) uses a variant of it.
Informational only. Not personalised financial, legal, or tax advice.