An inclusive date range counts a stated boundary as part of the range. If wording says “both days inclusive,” count the first date and the last date as well as every date between them. State that rule beside the result so the number has one reproducible meaning.
What does “both days inclusive” mean?
It means count both endpoints. From January 1 through January 5, both days inclusive, the counted dates are January 1, 2, 3, 4, and 5: five calendar dates. A same-day range is one date when both boundaries are included. Inclusive describes which boundary dates count; it does not by itself remove weekends or holidays.
How do you calculate inclusive days?
For calendar dates, subtract the start date from the end date and add one: inclusive days = end date − start date + 1. January 5 minus January 1 is four elapsed days; adding one counts both January 1 and January 5, so the inclusive total is five. Use the formula only when both endpoints are meant to count.
Compare all four boundary combinations
For January 1 to January 5, including both start and end counts five dates. Including only the start or only the end counts four. Excluding both counts January 2, 3, and 4, so the result is three. The ordinary elapsed difference is four midnights crossed; in boundary terms that commonly matches start excluded and end included. None of the four totals is universally correct until the wording or source rule identifies the intended boundaries.
Read “through,” “after,” and “until” carefully
“Both days inclusive” is explicit. “Through Friday” often signals that Friday counts, while “three days after Monday” normally treats Monday as the reference rather than day one. “Until Friday” can be ambiguous in ordinary language. Do not guess when the source controls a contract, filing, payment, or other important deadline: copy its exact wording and confirm the governing definition.
Use same-day and next-day checks
Two tiny examples reveal most off-by-one mistakes. For January 5 to January 5, counting both boundaries gives one date; an elapsed difference or both-excluded count gives zero. For January 5 to January 6, counting both dates gives two, while the elapsed difference gives one. If a calculator does not match the rule on these cases, review the boundary settings before trusting a longer range.
Elapsed time is not always a date count
Subtracting two LocalDate values measures midnight boundaries crossed. That is useful for elapsed calendar distance, but a notice may say that the delivery day counts or that the filing day does not. DayCount therefore asks for boundary choices instead of silently adding one to every result.
Know what a spreadsheet formula counts
If A1 is the start date and B1 the end date, =B1-A1 returns the elapsed calendar-day difference. Add one only when you have confirmed that both endpoint dates count. Excel and Google Sheets NETWORKDAYS count working weekdays at both endpoints when those dates qualify, but supplied holiday lists and local definitions can change the operational result. Label the formula’s boundary rule instead of leaving a bare total.
Record the rule with the answer
When a deadline matters, write “start excluded, end included” or the appropriate alternative next to the total. This makes the result reproducible and exposes whether a disagreement is mathematical or contractual. For legal, tax, payroll, or regulatory deadlines, confirm the governing definition rather than relying on a general calculator alone.