CorelyUp logoCorelyUpSearch
Menu

Free calculator

Days Between Dates Calculator

Count calendar days between two dates with full weeks, weekdays, weekend days and an inclusive option.

Your dates and calculated results stay in this browser tab and are not included in analytics events.

How to use this tool

Enter two valid calendar dates and choose whether the end date should be included in the count.

Transparent method

Formula and method

Exclusive total = the absolute calendar-day distance. Inclusive mode adds the ending calendar date, including one day when both dates are the same. Full weeks are total days divided by seven with the remainder shown separately.

Worked examples

  • Same date: 15 March to 15 March is 0 days exclusive or 1 day inclusive.
  • Adjacent dates: 1 March to 2 March is 1 calendar day exclusive.
  • Month end: 31 January to 1 February is 1 calendar day.
  • Year end: 31 December 2026 to 1 January 2027 is 1 calendar day.
  • Leap day: 28 February 2024 to 1 March 2024 is 2 calendar days.
  • Reversed dates keep their direction in the explanation while displaying an absolute duration.

Assumptions and limits

  • The primary duration is absolute; reversed input is identified separately and the signed difference remains available internally.
  • The same start and end date returns zero days exclusive and one day inclusive.
  • Weekdays mean Monday to Friday and weekend days mean Saturday and Sunday.
  • Public holidays are not identified or excluded.

How days between dates are counted

Exclusive counting measures date boundaries and excludes the end date. Inclusive counting adds the end date, so the same start and end date counts as one day when inclusion is selected.

Leap days are counted automatically when February 29 falls inside the range. Reversed dates show the same absolute duration with a clear note that the end date is earlier.

Weeks and remaining days

The calculator divides the calendar-day total into complete seven-day weeks and remaining days. It does not approximate months or years because their lengths vary.

Weekdays and weekend days

Weekdays are Monday through Friday; weekend days are Saturday and Sunday. This is calendar classification only, not a public-holiday or business-day calculation.

Date differences in Excel and Google Sheets

If the start date is in A1 and the end date is in B1, =B1-A1 returns an exclusive signed day difference when both cells contain valid spreadsheet dates. Add one only when your intended method includes the end date.

Common uses include counting days until a future date, days since a past date, project spans and calendar windows. Confirm whether the task expects inclusive or exclusive counting before sharing the result.

Frequently asked questions

How many days are between two dates?

Enter the start and end dates. The primary result shows the absolute calendar-day duration and explains the date order.

Does the calculator include the end date?

Not by default. Select Include the end date to add it; the counting method is displayed with the result.

How are leap years counted?

February 29 counts as a normal calendar day whenever it falls within the selected interval.

What happens if the end date is before the start date?

The calculator displays the absolute duration and clearly states that the end date is before the start date.

How many weekdays are between two dates?

The result counts Monday through Friday using the selected inclusive or exclusive method and reports Saturday and Sunday separately.

Are public holidays excluded?

No. This page classifies weekdays and weekend days only. Use the Business Days Calculator for a separate working-day estimate, noting its stated holiday limits.

Related guides

Related tools