Days between dates: six honest answers to one simple-looking pair

Take one pair of dates: Friday 5 March 2027 and Monday 8 March 2027. Ask how far apart they are and you can honestly answer 3, 4, 2, 1, 4 or 68, depending on what the person asking meant.

Three calendar days if you subtract, four if you count both days, and two working days if both ends count and the weekend does not. It is one if Friday is day zero.

A request that arrived at 3 Friday afternoon and was answered at 11 Monday morning took four working hours. That was sixty-eight hours on the wall clock between those same two moments.

None of those is wrong. Each is the right answer to a different question, and the subject comes down to knowing which question you were asked.

The difference between counting three and four is not a calendar quirk. It is the difference between a half-open and a closed interval, which mathematics settles by writing the brackets down and everyday language settles by argument.

Counting fence posts rather than the gaps between them is the same off-by-one problem. That error turns up wherever anything is counted between two markers.

What to take away

The same two dates, every way

Six numbers, one pair of dates, no arithmetic error anywhere in the table.

The four questions that fix the answer

Which unit. Calendar days measure elapsed time. Working days measure opportunity to act. Hours measure effort or service time. A document that says "days" with no qualifier usually means calendar days, and usually is not a reading anyone should rely on when the count decides a right.

Which endpoints. Exclusive counting is subtraction: the later date minus the earlier. Inclusive counting adds one because both days are in the set. "Clear days" goes the other way and excludes both ends, so it is one fewer than subtraction. All three are in daily use.

Which calendar. Calendar days need none. Working days need a working week and a list of closed days, and both belong to whoever set the deadline, not to you and not to this site. Nothing here supplies closures for any country, and the pages that do are publishing somebody else's document second-hand.

Which place. Two dates are only two dates once you know whose midnight they refer to. For part of every day, two places are on different dates, so a count that crosses a border has to say which local date governs.

How each unit is counted

Calendar days. Turn each date into a day number and subtract. Spreadsheets already store dates that way, which is why =B2-A2 is the whole formula. By hand, add up month lengths: 10 February 2027 is day 41 of its year, 23 November is day 327, and the difference is 286 days, which is 40 weeks and 6 days.

Working days. Walk from the first date to the last and count each day that is neither a rest day nor closed. [NETWORKDAYS](/working-days-per-month-excel) does exactly this and counts both endpoints. Monday 1 March to Monday 15 March 2027 gives 11 with both ends in. Close the Wednesday in between and it gives 10. Exclude the start day instead, with nothing closed, and it also gives 10, which is why two people can agree on a number and still disagree about how they got it.

Working hours. For each working day the interval touches, take the overlap between that day's window and the interval, then add the overlaps. Friday 15:00 to Monday 11:00 on a 09:00 to 17:00 window is two hours plus two hours. The weekend contributes nothing.

Endpoint conventions side by side

A working-day round trip shows the same thing from the other side. Add five working days to Monday 1 March and you land on Monday 8 March. Count the working days from the first Monday to the second with both ends in and you get six. Neither function is wrong. One measures a step, the other measures a set.

Direction is a reading too

Counting forward from a start answers "when will this land". Counting back from a fixed end answers "when must I begin". The two are not mirror images: adding then subtracting the same number of working days only returns you to a start that was itself a working day.

The forward case, and the four decisions buried in the phrase "business day", are set out under adding business days. The backward case, where an error makes you late rather than early, is under subtracting business days.

What to record with any count

Five items, one line each: the unit, the endpoint convention, the working week, the closure list with the date you took it, and the zone. Then the resulting number or date. A count stored without these cannot be checked, and six months later checking it is the only thing anyone wants to do.

A start plus a length is a different input

Two dates and a start plus a count look interchangeable and are not. Converting between them requires the endpoint convention, which is exactly the thing most often unstated.

Given two dates, the length is the difference, plus one if both ends count. Given a start and a length, the end is the start plus the length, minus one if both ends count. Each conversion needs the convention, and each is off by one without it.

The practical consequence is that a system storing spans should store them in one form and convert at the edges, rather than accepting both and hoping they agree. When they disagree the difference is one, which is small enough that nobody questions it and large enough to miss a deadline.

There is also a direction to preserve. Two dates carry an order; a start and a length carry a sign. A length recorded as a positive number, from a span whose end preceded its start, has silently lost the fact that it ran backward, and no later reader can recover it.

Common questions

Do I count today?

Only if the rule you are counting under says the first day is in the set. Subtraction says no. "Beginning on" says yes. "Clear days" says neither today nor the last day counts. Read the wording before you reach for a convention.

Is "a week" seven days or five?

Seven calendar days and five working days cover the same span on a Monday-to-Friday calendar, so the two readings agree only when the interval is a whole number of weeks. For any other length they differ, and the difference grows with every weekend crossed.

My spreadsheet and my hand count differ by one. Which is right?

Both, probably. The spreadsheet subtracted and you counted both ends, or you used a function that counts both ends and then compared it to a step count. Decide which convention the situation calls for and make the other one match.

Which unit should a contract use?

Whichever matches what the interval is for. Waiting periods are elapsed time and suit calendar days. Work that someone must do suits working days. Service targets measured inside office hours suit hours. Mixing units inside one document is how the same deadline gets two dates.