Days Between Two Dates

This calculator counts the number of calendar days between a start date and an end date, with optional inclusive counting and weekday breakdown. It answers trip length, rental periods, school terms, and any question phrased as how many days from X to Y without opening a spreadsheet or debating month lengths by hand.

Inclusive versus exclusive counting

Exclusive counting measures the gap between endpoints: January 1 to January 3 equals two days. Inclusive counting includes both endpoints — three days in the same example. Contracts, leases, and school policies disagree on which convention applies, so match the toggle to your document before signing or invoicing.

Spreadsheets often use end minus start for exclusive days when cells are date-formatted, and end minus start plus one for inclusive totals. Write the convention once in the project charter so finance and operations do not argue from different numbers on the same trip or rental.

Weekdays, weekends, and leap years

The breakdown shows how many weekdays and weekend days fall inside the span. Leap years add February 29; the day count crosses that extra day automatically when the range includes it. Staffing plans that differ on Saturday and Sunday benefit from the split even when the contract bills calendar days.

Workday-only math belongs on the business days calculator, which can exclude US federal holidays. Hour-level spans across clock times use hours between dates when sub-day precision matters.

How to use the calculator

Enter start and end, pick inclusive or exclusive, and calculate. Swap dates if reversed — the span length stays the same though labels may reorder. Share URLs with query parameters when supported so teammates reproduce identical ranges in audits.

Print the end month from monthly calendars when the window must appear on a wall chart beside the numeric total. Highlight start and end on a printed month spanning both dates; off-by-one errors become obvious when highlighted cells disagree with the integer.

Spreadsheets, SQL, and export hygiene

Excel DATEDIF with unit D returns day differences between date cells. SQL databases use DATEDIFF or simple subtraction depending on dialect — confirm whether the function is inclusive. Time zones do not change calendar-day math when both sides are civil dates without clock times.

When exporting to BI tools, store start date, end date, inclusive flag, and day total in adjacent columns. Future readers should not reverse-engineer inclusive logic from the integer alone. Insurance waiting periods often state calendar days from enrollment — mirror the inclusive flag to the policy definition before approving claims.

Worked examples

A fourteen-night hotel stay from check-in to check-out often uses exclusive counting — verify the property’s policy before disputing a charge. Inclusive counting would add a day that the front desk may not recognize. A school district counts inclusive days for attendance recovery programs spanning winter break.

Cross-check federal holidays on 2026 holidays when only certain weekdays qualify, even though this page counts calendar days by default. Permit validity windows often cite maximum calendar days from issuance — enter issuance and expiration endpoints with the agency’s inclusive rule before scheduling inspections near the deadline.

When days are not enough

Stakeholders may want weeks or months: see weeks between dates, months between dates, and years between dates. Adding days to a start date instead of measuring a span is the date calculator. Richer Y/M/D breakdowns with optional workday columns appear on date duration when you need one page to speak to both finance and HR.

Mixing inclusive and exclusive mid-project causes one-day errors that matter on short deadlines. Confusing calendar days with business days on legal text produces overdue notices a day early or late — read the contract noun carefully before choosing a calculator.

Travel, per diem, and expense reports

Corporate travel policies count inclusive or exclusive days for per diem differently than hotel night counts. A Tuesday departure and Friday return may be three hotel nights but four inclusive calendar days for meal allowances — match the toggle to finance policy before submitting expenses.

International trips crossing the international date line can add complexity when airline tickets use local dates at each end. This calculator works on civil dates you enter; confirm which city’s calendar date applies at each endpoint before arguing with payroll.

Clinical trials and study protocols

Protocol documents define visit windows as days from randomization or from day one of treatment. Enter those anchors as start and visit dates with the protocol’s inclusive rule. Regulatory submissions attach day counts beside ISO dates in case report forms — keep both in sync from one calculation pass.

Adverse event timelines that cite “within thirty days of dose” should use dose date as start, not admission date, unless the protocol explicitly overrides. Mis-anchored spans invalidate safety narratives during audit.

Real estate and short-term rentals

Lease day-count clauses differ from nightly rental platforms. A platform “seven-night stay” may map to eight inclusive calendar days or seven exclusive nights depending on checkout time rules. Read the platform contract noun before comparing to this calculator’s integer.

Security deposit return statutes sometimes cite days from move-out inspection. Use inspection date as one endpoint and today or statutory deadline as the other with the inclusive flag mirrored to state law summaries your counsel approved.

Science fair protocols that log experiment length from planting to harvest should state inclusive or exclusive counting in the notebook header so published methods sections match the day total reviewers see in raw data tables during replication attempts.

Carrier quotes that mix business transit days with calendar coverage should use this page only for the calendar span between ship and delivery dates, then compare separately against the carrier’s business-day promise in the rate quote.

Related tools

Continue on the date tools hub with date duration, days until, and days ago.