tooldura
Math & Numbers

Inclusive or Exclusive: Why Day Counts Come Out One Off

T
tooldura editorial
7 min readUpdated November 6, 2026Open tool →

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.

SituationWhat is countedMonday to Friday
Hotel stayNights, so the departure day is not charged4 nights
Event or festival running both daysEvery day it is open5 days
Elapsed time, countdownsMidnights crossed (end − start)4 days
Most legal deadlinesExclude the trigger day, include the last4 days
Excel B1 − A1Plain subtraction4
Excel NETWORKDAYSBoth ends included5
⚖️

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.

Open Days Between Dates Calculator →

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.

1

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.

2

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.

3

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.

4

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

Found this guide useful? Pass it on.

Related Tools

Keep Reading