Dates & Time

How to Calculate Days Between Two Dates

Count calendar days between dates, understand inclusive and exclusive counting, handle leap years and switch to business-day calculations when needed.

Updated 2026-08-24By OfficeCalculator.Net Editorial TeamPractical formulas + worked examples
Quick answerFor elapsed calendar days, subtract the start date from the end date. Decide first whether your rule is exclusive or inclusive, because that can change the result by one day.

The basic days-between-dates calculation

The simplest date difference measures elapsed full calendar days between a start date and an end date. Conceptually, the calculation is:

Total elapsed days = End date − Start date

For example, from January 1 to January 2 is one elapsed day. From January 1 to January 8 is seven elapsed days. This is often called exclusive-start counting because the start date marks the beginning of the interval rather than a completed day.

Inclusive versus exclusive counting

Many date-counting disagreements are not calculation errors; they are rule differences. If a schedule says “including both the start and end date,” add one day to the ordinary elapsed-day result. A January 1 through January 8 inclusive range contains eight named calendar dates even though the elapsed duration is seven days.

Contracts, school schedules, leave policies, delivery windows and legal deadlines may define endpoints differently. Before relying on a date result, confirm whether the start date, end date, both or neither should count.

How to count manually across months

For short spans, count forward day by day. For longer spans, split the period into the remaining days of the first month, any full months in the middle, and the elapsed days in the final month. Remember that month lengths vary and February changes in leap years.

For example, a span from January 28 to February 5 crosses a month boundary. Count Jan 28→29, 29→30, 30→31, 31→Feb 1, then Feb 1→2, 2→3, 3→4 and 4→5: eight elapsed days.

Leap years and February 29

A leap year adds February 29. Under the Gregorian calendar rule, years divisible by 4 are generally leap years, except century years that are not divisible by 400. That is why 2000 was a leap year but 1900 was not.

For any range crossing February in a leap year, automated date arithmetic is safer than assuming every year has 365 days.

Calendar days versus business days

Calendar days include every day. Business-day calculations usually remove weekend days and may also remove holidays or company closure dates. The exact definition can differ by country, industry and organization.

If a deadline is stated in “working days,” do not use a simple calendar-day subtraction unless the rule explicitly treats weekends as working days. Use the dedicated business-day tools and verify the holiday policy that applies to your situation.

Adding or subtracting days from a date

A related task is finding the date that falls a certain number of days before or after a starting date. Calendar-day addition counts every day. Working-day addition skips non-working days according to the chosen rule. This distinction matters for shipping estimates, payroll cutoffs, project plans and service deadlines.

Practical uses

  • Project duration and milestone planning.
  • Invoice, subscription and payment periods.
  • School and study schedules.
  • Travel countdowns and event planning.
  • Notice periods and administrative timelines.
  • Tracking how long a process, order or task has been open.

Common date-counting mistakes

  • Counting both endpoints when the rule expects elapsed days.
  • Assuming every month has 30 days.
  • Forgetting February 29 in a leap year.
  • Using calendar days when a deadline is defined in business days.
  • Ignoring time zones when timestamps rather than dates are involved.

Frequently asked questions

Does the start date count as day one?

It depends on the rule. Elapsed duration normally starts at zero on the start date; inclusive schedules may count that date as day one.

Are weekends included?

They are included in ordinary calendar-day calculations. Business-day calculations typically exclude designated weekend days.

Can I use the same method for months and years?

Days can be converted to approximate months or years, but calendar month/year differences are better expressed using actual calendar boundaries because months have different lengths.

Use the calculators instead of doing every step by hand.

Enter your own values, review the result, then use the guide above to understand the formula and assumptions.