How many days between 1 January and 26 September? The answer is 268 — or 269, depending on a convention most guides never mention. Learning how to calculate days between dates correctly means understanding inclusive vs. exclusive counting, the leap-year gotcha, and the difference between calendar days and business days.
This guide gives you the honest date-math walkthrough: a worked hand calculation, the table showing how the same date pair gives different answers under each convention, Excel formulas, and business-day counting. Every number is computed step by step.
For instant answers, our free Date Calculator computes the difference between any two dates — with the counting convention stated explicitly.
Table of Contents
- how to calculate days between dates by Hand
- Inclusive vs. Exclusive: The Trap Everyone Falls Into
- The Leap-Year Gotcha
- Calendar Days vs. Business Days
- Excel and Google Sheets Formulas
- how to calculate days between dates for Contracts and Deadlines
- Try It: Calculate Days Between Dates
- Frequently Asked Questions
how to calculate days between dates by Hand
The reliable hand method: convert each date to its day-of-year number (1 January = day 1, 31 December = day 365 or 366), then subtract.
Worked example: 1 January 2026 → 26 September 2026.
First, the day-of-year for 26 September 2026 (not a leap year — 2026 is not divisible by 4):
- January 31, February 28, March 31, April 30, May 31, June 30, July 31, August 31 → cumulative through August: 31+28+31+30+31+30+31+31 = 243
- Plus 26 days of September: 243 + 26 = day 269
1 January is day 1. Days elapsed: 269 − 1 = 268 days. That is the standard “exclusive of start, inclusive of end” count — the number of midnights between the two dates, and what most date calculators return.
Spanning years? Add the remaining days of the first year plus the day-of-year of the end date. Example: 15 November 2025 → 10 February 2026. Days remaining in 2025 after 15 Nov: 30 − 15 (rest of November) + 31 (December) = 46. Day-of-year of 10 Feb 2026: 31 + 10 = 41. Total: 46 + 41 = 87 days.
Honest note: hand calculation is error-prone across leap years and month boundaries — it is a good way to understand date math and a bad way to do it for anything important. Use the Date Calculator for real answers; use this section to understand what it is doing.
Inclusive vs. Exclusive: The Trap Everyone Falls Into
Here is the differentiator no ranking page states clearly: the same date pair gives different answers depending on whether you count the start date. This convention choice is the single most important part of learning how to calculate days between dates — more important than the arithmetic itself. Most guides silently pick one convention, and readers comparing two tools get different numbers and conclude one is broken. Usually both are right — they are counting differently.
For 1 January 2026 → 26 September 2026:
| Convention | What it counts | Result | When to use it |
|---|---|---|---|
| Exclusive of start (standard) | Midnights between the dates | 268 days | Age, tenures, “how long ago,” most calculators |
| Inclusive of both | Calendar days touched, start and end included | 269 days | Hotel nights are exclusive; project day-counts and “day 1 to day N” plans are often inclusive |
The one-day gap is the entire trap. A project running “1 Jan to 26 Sep” staffed for 268 days is fine under the exclusive convention and one day short under the inclusive one. Hotel bookings sidestep this by selling nights (inherently exclusive of the checkout day). Whenever a date difference matters — contracts, payroll, subscriptions — state the convention explicitly. “268 days (exclusive of start date)” ends arguments; a bare number starts them.
Our Date Calculator states its convention on the result for exactly this reason. If you are computing an age rather than a gap, our Age Calculator and the age-calculation guide handle the years-months-days breakdown with the borrow method.
The Leap-Year Gotcha
Leap years add a day (29 February) that shifts every day-of-year after February by one. Forget it and multi-month spans across a leap February come out one day short.
Worked example: 28 February 2024 → 1 March 2024. 2024 is a leap year (divisible by 4). Day-of-year: 28 Feb = day 59 (31 + 28); 1 Mar = day 61 (31 + 29 + 1). Difference: 61 − 59 = 2 days (the 29th sits between them).
Same dates, non-leap year: 28 February 2025 → 1 March 2025. Day-of-year: 28 Feb = day 59; 1 Mar = day 60 (31 + 28 + 1). Difference: 60 − 59 = 1 day.
Same calendar dates, different answers — 2 days vs 1 day — purely because of the leap day between them. Any date span crossing February in a leap year (2024, 2028, 2032…) needs the +1; spans in non-leap years do not. The leap rule itself: divisible by 4, except century years unless divisible by 400 — so 2000 was a leap year and 1900 was not. When in doubt about whether a year qualifies, that rule (not “every four years”) is the authority.
Calendar Days vs. Business Days
Sometimes you do not want all days — you want working days. Business days exclude weekends (and usually public holidays): the unit of project plans, delivery estimates, and notice periods.
Worked example: how many business days from Monday 6 April 2026 to Friday 17 April 2026 (exclusive of start)?
- Calendar days: 17 − 6 = 11 days
- Weekends inside: Sat 11 – Sun 12 April → 2 weekend days
- Business days: 11 − 2 = 9 business days
The quick estimation method: business days ≈ calendar days × 5/7. For 11 calendar days: 11 × 5/7 = 7.86 ≈ 8 — close to the true 9 but not exact, because the estimate does not know where weekends fall. Fine for rough planning, wrong for contracts.
Public holidays are the part no formula handles automatically — they vary by country, province, and year. Pakistan’s holidays (Eid, Independence Day, etc.) follow the lunar calendar for religious observances, so they shift yearly. Any business-day count for contractual purposes must layer the actual holiday list on top; a calculator that does not ask about holidays is giving you weekdays, not true business days. Our date calculator handles the weekday math; bring your own holiday list for the rest.
Excel and Google Sheets Formulas
Three formulas cover nearly every need:
- Days between (exclusive of start):
=DAYS(end_date, start_date)or simply=end_date - start_date. For 26-Sep-2026 minus 1-Jan-2026: 268. - Inclusive of both:
=DAYS(end_date, start_date) + 1→ 269. The +1 is the entire inclusive/exclusive difference, made explicit. - Business days:
=NETWORKDAYS(start_date, end_date)— note this one is inclusive of both endpoints by default, and accepts an optional holiday list as a third argument:=NETWORKDAYS(start, end, holidays_range).
Watch the NETWORKDAYS convention trap: it counts both endpoints, while DAYS counts exclusive-of-start. Mixing the two in one spreadsheet without noticing is a classic off-by-one source. And the old =DATEDIF(start, end, "D") also works but is undocumented — DAYS is the modern choice. For the finer breakdown of date components, the ordinal date system (day-of-year numbering) is the formal version of the hand method above.
how to calculate days between dates for Contracts and Deadlines
The highest-stakes version of how to calculate days between dates is the contractual one: notice periods, delivery deadlines, warranty windows. Here the inclusive/exclusive choice from the previous section is not academic — it decides whether a deadline is met or missed.
The professional convention: for notice periods and deadlines, count exclusive of the start date and inclusive of the end date. A “30-day notice period starting 1 October” means the notice is complete at end of day on 31 October — 30 days counted as 2–31 October. State the convention in the contract itself (“30 days, exclusive of the date of notice”) and half of all disputes evaporate.
Two practical rules for anyone who must calculate days between two dates for legal or business purposes:
- Write the end date, not just the duration. “Deliver within 14 days of 3 November” is ambiguous; “deliver by 17 November 2025” is not. Always convert the duration into an explicit calendar date and have both parties confirm it.
- Clarify business vs. calendar days in writing. “14 days” in a contract usually means calendar days unless specified — but many people assume business days. The five minutes spent writing “14 calendar days” saves weeks of argument.
When a deadline truly matters, compute it twice — once by hand, once with the calculator — and confirm both agree. That is how to calculate days between dates the way a careful professional does: method plus verification, with the convention written down.
Try It: Calculate Days Between Dates
Now that you know how to calculate days between dates by hand, enter any two dates in the free Date Calculator — it shows the difference with the counting convention stated, so you always know whether you are looking at 268 or 269. For ages specifically, the Age Calculator gives the years-months-days breakdown.
Frequently Asked Questions
Does subtracting dates include the start date?
By standard convention, no: 26 Sep 2026 minus 1 Jan 2026 is 268 days (exclusive of start). Including both endpoints gives 269. Always state which convention you are using — the one-day difference causes endless confusion.
How do I calculate days between two dates in Excel?
Use =DAYS(end_date, start_date) for the standard exclusive count, add +1 for inclusive, or =NETWORKDAYS(start, end) for business days (inclusive of both endpoints, with an optional holiday range).
How do leap years affect day counts?
A span crossing 29 February in a leap year contains one extra day. Example: 28 Feb → 1 Mar is 2 days in leap year 2024 but 1 day in 2025. Always check whether a leap day falls inside your span.
How do I count business days between two dates?
Subtract weekend days (and public holidays) from the calendar-day count. In Excel: =NETWORKDAYS(start, end, holidays). Remember it counts both endpoints inclusively, and supply your own holiday list — no formula knows your country’s holidays.