My date calculations have caused scheduling problems more than once — I kept assuming counting days between two dates was trivial until a notice period made the exact number matter.
Counting days between two dates sounds completely trivial — until a legal deadline, a notice period, a payment due date, or a probationary period depends on it. The calendar is full of irregularities (months of different lengths, leap years) that make manual counting genuinely error-prone. Here's how to do it right.
Why Manual Counting Goes Wrong
- Off-by-one: is the start date counted? The end date? Conventions vary by context.
- Month-length confusion: February has 28 or 29 days; months range from 28 to 31.
- Leap year blindness: 2024, 2028 are leap years; 2100 is NOT (century years are only leap years if divisible by 400).
Our time between dates calculator handles all this automatically. For age calculations specifically, our age calculator is purpose-built.
Inclusive vs Exclusive Counting
This causes the most confusion in legal and contractual contexts. Does today count as day 1 or day 0? Exclusive: today not counted — 3 days from Monday = Thursday. Inclusive: today is day 1 — 3 days from Monday = Wednesday. UK law varies by context — statutory notice periods and court deadlines each have specific rules. When stakes are high, check the specific wording and confirm with a professional.
Calendar Days vs Working Days
Many deadlines are expressed in working days — calendar days excluding weekends and public holidays. The UK has 8 bank holidays in England and Wales (different in Scotland and Northern Ireland). Five working days from a Monday before a bank holiday Tuesday doesn't land where you'd expect. For critical deadlines in working days, always count manually through the actual calendar for that specific period.
Practical Applications
- Tenancy notice periods (typically 1-2 months)
- Consumer returns windows (14 or 30 days)
- Invoice payment terms (30, 60, 90 days)
- Employee probationary periods
- Event countdowns
Spreadsheet Date Maths
In Excel and Google Sheets, you can subtract one date from another directly to get the number of days: =B1-A1. Format the result cell as a number, not a date. For working days, =NETWORKDAYS(A1,B1) counts business days between two dates, excluding weekends and optionally specified holidays.
For anything with meaningful consequences — legal, financial, or contractual — use a calculator rather than counting on fingers. Calendar maths is just tricky enough to produce one-day errors that turn into real problems.
Further reading: GOV.UK has guidance on legal time limits and deadline counting in civil proceedings. Visit GOV.UK for guidance on legal deadlines.
The Inclusive vs Exclusive Counting Problem
One of the most common sources of date calculation errors is ambiguity about whether the start and end dates are included in the count. A notice period of "30 days" from a date given on the 1st might mean: the 30th (exclusive of start, inclusive of end), or the 31st (inclusive of both), depending on the contract or convention. Always check the specific wording when dates have legal or financial significance. When counting days for personal planning, inclusive counting — where both the start and end date are counted — is usually the more intuitive approach.
Months and Leap Years
Months have different lengths — 28, 29, 30, or 31 days — which makes "adding a month" ambiguous. Adding one month to 31 January might produce 28 February (in a common year), 29 February (in a leap year), or could be interpreted as 3 March if rounding to the end of the shorter month. In legal contexts, "one month" from a specific date typically lands on the same day number of the following month. Leap years add one day to February every four years (with century-year adjustments), which changes calculations spanning a February in a potential leap year.
Working Days vs Calendar Days
Many business and legal timelines are specified in working days — calendar days excluding weekends and public holidays — rather than calendar days. A 10 working day period starting on a Monday before a bank holiday weekend might span nearly three calendar weeks. Always clarify which type of day is meant for any time-sensitive calculation. In the UK, public holidays vary between England, Scotland, Wales, and Northern Ireland, which adds another variable for cross-border working day calculations.
Practical Applications
Accurate day counting matters for contract notice periods, payment terms, legal deadlines, prescription windows, tenancy agreements, and insurance policy dates. In each case, getting the count wrong by one day can change the outcome. Using a calculator that explicitly shows the start date, end date, and count method — and verifying against a physical calendar for critical dates — is the most reliable approach for any date with a material consequence.