How to Calculate the Days Between Two Dates

To calculate the days between two dates, subtract the earlier date from the later date. That gives the elapsed calendar days. If you want to count every calendar date in the range, including both the start and finish, add one. Decide which question you mean before choosing a calculator or spreadsheet formula.

For example, November 9 to November 20, 2026 is 11 elapsed days, but a schedule running on every date from November 9 through November 20 covers 12 calendar dates. Both answers can be correct. They describe different things.

Why does including the start date change the answer?

Imagine two neighboring dates on a calendar. Moving from Monday to Tuesday crosses one day boundary. However, marking both Monday and Tuesday selects two dates. Subtraction counts the distance between the dates; inclusive counting counts the dates themselves.

The same-date test makes the distinction easy to remember. From November 9 to November 9, no days have elapsed, so the difference is zero. A one-day event held on November 9 still occupies one calendar date. Adding one is appropriate for that inclusive count, not for every date calculation automatically.

For a range with the finish on or after the start, use these rules: elapsed days = end date − start date; inclusive calendar dates = end date − start date + 1. Write the chosen rule beside your answer so someone else can reproduce it.

Use Date Calculation in Windows Calculator

For a quick calculation without building a spreadsheet, open the Windows Calculator app. Open its navigation menu and choose Date Calculation. Select Difference between dates, then choose the earlier date under From and the later date under To. Read the day count under Difference. Microsoft documents this workflow in its date-calculation guide.

Try the November 9–20 example first, checking that both years are 2026. The elapsed result should be 11 days. If your planning question includes both dates, record 12 separately and label it as inclusive. Do not silently adjust the displayed answer without explaining why.

Read the selected month and year before trusting a result, especially when scrolling a calendar picker across December and January. A correct calculation with the wrong year is still the wrong answer for your plan.

Calculate the difference in Excel

For a reusable worksheet, label A1 Start date, B1 End date, and C1 Elapsed days. Put the start in A2 and the finish in B2. In C2, enter =DAYS(B2,A2). The order matters: Excel’s DAYS function takes the end date first and the start date second. See the official DAYS reference.

Use actual Excel dates, not text that merely looks like a date. One unambiguous way to enter this example is =DATE(2026,11,9) in A2 and =DATE(2026,11,20) in B2. DATE takes year, month, and day in that order. Microsoft recommends four-digit years in its DATE documentation.

C2 returns 11. If you need an inclusive count, label D1 Inclusive dates and enter =C2+1 in D2. Keeping both answers in separate, named columns makes their difference visible rather than burying it in an unexplained formula.

Format the start and end cells as dates, but the result as a number. If the result looks like an unexpected date, check the cell’s number format before changing your arithmetic. Microsoft’s date-difference guidance also distinguishes day counts from years, months, and other duration outputs.

Check month boundaries and leap years

Do not subtract only the day-of-month numbers when the range crosses a month boundary. November 28 to December 3, 2026 is five elapsed days, not 3 minus 28. Count the transitions: November 29, November 30, December 1, December 2, and December 3. Including November 28 as an occupied date makes six dates altogether.

The year can change the answer around February. February 28 to March 1 is one elapsed day in 2027, but two in 2028 because February 29 lies between them. Enter the full year rather than assuming the same month-and-day pair always has the same distance.

For a short interval, use a paper calendar as an independent check. Start at the earlier date, move one square for each day, and count the moves until you reach the finish. Count the marked squares instead only when you deliberately want an inclusive total.

What if the result is negative or unexpectedly large?

A negative spreadsheet result often means the start and end were reversed. Check the input labels and the argument order before deciding whether that is an error. In a countdown worksheet, a past target date might intentionally produce a negative number; in a forward event schedule, it usually deserves a closer look.

For an unexpectedly large answer, check the year and the date interpretation. A notation such as 04/05 can mean different dates in different locales. Spell out the month when communicating the result, or use separate year, month, and day values when entering it. Avoid two-digit years in a shared plan.

Keep calendar days separate from other questions

Calendar-day differences include weekends and holidays. They do not tell you how many workdays, school sessions, or opening days fall in a range. Likewise, counting calendar dates is not a calculation of precise elapsed hours between timestamped events. Keep the unit and the intended use beside the number.

For a contractual, court, tax, or other formal deadline, use the issuing organization’s counting rules rather than assuming this general arithmetic determines the due date. For ordinary planning, a useful final note is explicit: “November 9 through November 20, 2026: 12 calendar dates, both endpoints included.”

If a visible paper plan helps, you can browse undated monthly desk planners on Amazon. A planner is optional; clear start and finish dates and a stated counting rule do the essential work.