A conference runs from Monday to Friday. Ask how many days that is and most people say five. Subtract the dates and you get four. Neither answer is a mistake. They count different things, and almost every disagreement about a deadline, a notice period or a hotel bill comes down to which of the two someone had in mind.
Fences and Posts
Programmers call this the fencepost problem. A fence 40 metres long with a post every 10 metres has four sections but five posts. Dates behave the same way. The days are the posts, and the gaps between one midnight and the next are the sections.
Subtracting one date from another counts the sections. From 5 January to 9 January there are four gaps, so four days have elapsed. Counting the days that appear on the calendar counts the posts, and there are five of them: the 5th, 6th, 7th, 8th and 9th.
The general rule is short. Elapsed days = end − start. Days on the calendar = end − start + 1. The only question is which one the situation calls for, and that is settled by convention, not arithmetic.
Who Counts Which Way
Typical conventions. Contracts, local law and company policy can override any of them, so check the wording that applies to you.
| Situation | What is counted | Monday to Friday |
|---|---|---|
| Hotel stay | Nights, so the departure day is not charged | 4 nights |
| Event or festival running both days | Every day it is open | 5 days |
| Elapsed time, countdowns | Midnights crossed (end − start) | 4 days |
| Most legal deadlines | Exclude the trigger day, include the last | 4 days |
| Excel B1 − A1 | Plain subtraction | 4 |
| Excel NETWORKDAYS | Both ends included | 5 |
How Courts Count a Deadline
Legal deadlines can't live with two answers, so they pick one, and most systems pick the same one. The day of the event that triggers the period is left out, counting starts the next day, weekends and public holidays inside the period count like any other day, and the last day is included. If the last day lands on a weekend or public holiday, the deadline usually moves to the next working day.
The details belong to whoever sets the deadline. A court, a country, a contract or a government office can each word it differently, and the rules get revised, so the text that governs your deadline is what decides.
In practice that means a 14-day period triggered on Monday 2 March 2026 ends on Monday 16 March. Start on the 2nd, add 14, and you land on the answer. That is the elapsed-days count, the calculator's default with the end-date box left unticked.
Calendar days or working days?
Read the wording before you count. "Within 10 days" and "within 10 working days" can end a full week apart, and a deadline stated in working days skips every weekend and public holiday in between. If the text does not say which, ask whoever set the deadline rather than picking the one that suits you.
Why Your Spreadsheet Disagrees With Itself
Excel stores each date as a serial number, with 1 January 1900 as serial 1, so subtracting two date cells gives the elapsed count. Its NETWORKDAYS function counts business days with both ends included. Microsoft's own example returns 110 workdays from 1 October 2012 to 1 March 2013, and you only get 110 if both of those weekdays are counted.
The result is that =B1-A1 and =NETWORKDAYS(A1,B1) follow opposite conventions in the same sheet. Over a single working week the plain subtraction says 4 and NETWORKDAYS says 5, and comparing the two figures makes it look as if a weekday went missing.
WORKDAY, which adds working days to a date, does the opposite of NETWORKDAYS and never counts the start date. Microsoft's example adds 151 working days to 1 October 2008 and gets 30 April 2009. This calculator matches both: its business-day count follows the end-date checkbox, and adding business days starts on the first weekday after the start date. Microsoft's two examples give the same answers here.
Count the days both ways
Toggle the end date to see the difference, with business days and weeks alongside.
A Business Day Is a Local Rule
Monday to Friday is the common default, not a universal one. The United Arab Emirates moved its federal government from a Friday and Saturday weekend to Saturday and Sunday on 1 January 2022, with Friday as a half day, and other countries keep other weekends. A count that is right for a London office can be wrong for a supplier in another country.
Public holidays are the bigger variable. They change by country, by state or region, and sometimes by employer, and some of them move from year to year. That is why this calculator counts only Monday to Friday and leaves holidays to you. A tool that quietly applied one country's holiday list would be wrong everywhere else without saying so.
As a sanity check, a year has 52 full weeks plus one or two extra days. That gives 260 weekdays plus however many of those extra days are weekdays: 260 or 261 in a common year, 260 to 262 in a leap year. Subtract the holidays and you have the working year.
Counting Days Without Counting Hours
The reliable way to count days is to turn each date into a single day number and subtract. The system astronomers use is built on the Julian Period, which Joseph Scaliger proposed in 1583. Its Julian Day Number counts days continuously from noon on 1 January 4713 BC in the Julian calendar, so the interval between two observations is one subtraction regardless of calendars, months or leap years.
The tempting shortcut in code is to subtract two timestamps and divide by 86,400,000 milliseconds. That breaks wherever the clocks change. Across a spring daylight saving change one calendar day is only 23 hours long, so the division comes out just under a whole number and rounding down loses a day. This calculator works on day numbers in the Gregorian calendar, so a short day or a long one is still one day.
Before You Trust a Day Count
Four questions settle most disagreements before they start.
Does the first day count?
Deadlines and elapsed time usually start counting the day after the trigger. Events and bookings usually count the first day.
Does the last day count?
If the answer should read like a list of dates on a calendar, add one. If it should read like time passed, don't.
Calendar days or working days?
A "10-day" notice period and a "10 business day" one differ by at least four days, more if a holiday falls in between.
What happens on a weekend or holiday?
Many legal rules roll a deadline forward to the next working day. Contracts sometimes roll it back instead. Read the clause rather than assuming.
Frequently Asked Questions
Related Tools
Keep Reading
Date Arithmetic Is Harder Than It Looks: Leap Years and Feb 29
One month after 31 January has no single right answer. How months create ambiguity, and when a leap-day baby legally turns 18.
Ten Digits or Thirteen: Reading a Unix Timestamp Without Guessing
Milliseconds read as seconds land in the year 55,840. Why the digit count gives the unit away, why JSON rounds off nanoseconds, and where 2038 still bites.
Percentage Change vs Percentage Points, and Other Costly Confusions
Down 50 percent then up 50 percent leaves you down 25. Why percentages are not symmetric, and how stacked discounts really multiply.
Why 1/3 Never Ends: Fractions, Decimals and Common Denominators
1/8 ends after three digits and 1/3 never does. The prime-factor rule behind terminating decimals, why 1/7 cycles through six digits, and why 0.1 + 0.2 misbehaves.