Days Between Dates: Why Date Math Keeps Surprising Everyone

The fence-post problem: 3 or 4 days?

From Monday to Friday is four days of DIFFERENCE (Tue, Wed, Thu, Fri) but five days of DURATION if both ends count (Mon through Fri). Neither answer is wrong; they answer different questions. Rental cars and hotels bill nights (difference); event tickets and prescriptions usually speak in inclusive days (duration).

The classic trap: a deadline '14 days from March 1' means March 15 if day one is excluded (the common legal convention) but March 14 if March 1 itself counts. Contracts and courts almost always exclude the starting day; when the stakes matter, the only safe move is to ask which convention applies.

Leap years: one rule, two exceptions

A year is a leap year if it divides by 4, EXCEPT century years, which must divide by 400. So 2024 was a leap year, 1900 was not, and 2000 was. The double exception exists because the solar year is about 365.2422 days: adding a day every 4 years overshoots slightly, and skipping three century leap days every 400 years brings the average to 365.2425, close enough to drift only one day in about 3,200 years.

The practical consequence: any span crossing a February needs to know the year. The gap between January 15 and March 15 is 59 days in a common year and 60 in a leap year, and 'same date next year' after February 29 simply does not exist three years out of four.

Adding months is not adding days

'One month later' from January 31 lands on a date that does not exist (February 31). Software resolves this in two different ways: clamping to the last valid day (February 28 or 29) or overflowing into March 2 or 3. Banks, subscription services and spreadsheets do not all pick the same answer, which is why a subscription billed 'monthly' on the 31st quietly drifts to the 28th.

This is also why 'thirty days' and 'one month' are different promises: a 30-day return window starting January 31 ends March 2; a one-month window ends February 28. Over a year, twelve months and 365 days differ from '12 × 30 days' by five or six days, enough to matter in interest calculations, which is why finance invented the artificial 360-day year (each month exactly 30 days) to keep the math uniform.

Working days: where geography enters math

Business-day counting starts easy (skip Saturdays and Sundays: 7 calendar days contain 5 working ones) and immediately gets local. Public holidays differ by country, by region within countries and by year, since several holidays float with Easter or lunar calendars. 'Ten business days' spanning Easter differs by two days between the Netherlands and the US.

The reliable procedure: count calendar days, subtract weekends (roughly two per seven days, but count them, do not estimate), then subtract the specific holidays of the specific place in the specific year. A date calculator handles the weekend part exactly; the holiday list is the part you must confirm locally, because no formula knows your country's calendar.

One final habit prevents most real-world damage: when a deadline matters, convert 'in three weeks' or 'ten business days' into an explicit dated day ('Thursday, September 17') at agreement time. Every trap above only bites while the date is still implicit.