How to Calculate Days Between Two Dates (4 Easy Ways)

How many days are there until a deadline, between two invoices, or since a project started? Counting squares on a calendar is slow and easy to get wrong, especially when the dates cross several months.

This guide shows you four reliable ways to calculate the days between two dates: a free calculator, a quick method by hand, and formulas for Excel and Google Sheets. You also learn when to add 1 and how to count only working days.

Short answer: Subtract the earlier date from the later one. From 1 March to 30 June 2026 is 121 days. If you want to count both the first and the last day, add 1, which gives 122 days. In Excel or Google Sheets, use =B2-A2 or =DAYS(B2,A2).

The quickest way: use a days-between calculator

The free Countdown and Days Between calculator does the counting for you:

  1. Open the tool and choose the Between tab.
  2. Pick the Start date and the End date.
  3. Tick Include the end date if both days should count.
  4. Read the answer in days, plus weeks and days, months and days, and hours.
Countdown tool Between tab showing 121 days from March 1 to June 30, 2026
From 1 March to 30 June 2026 is 121 days, or 17 weeks and 2 days.

Need a date instead of a number? The From today tab adds or subtracts any number of days (up to 10,000) from today or another date, so you can find the date 30, 60 or 90 days from now.

How to count days between dates by hand

When the dates fall in different months, split the count into three parts:

  1. Days left in the first month. Subtract the start day from the length of that month.
  2. Full months in between. Add the length of each whole month.
  3. Days in the last month. Add the end day.

Example: 1 March to 30 June 2026.

PartCalculationDays
Rest of March31 − 130
AprilFull month30
MayFull month31
JuneUp to the 30th30
Total121

Days in each month

MonthDaysMonthDays
January31July31
February28 (29 in a leap year)August31
March31September30
April30October31
May31November30
June30December31

A leap year is any year divisible by 4, except century years, which must be divisible by 400. So 2028 is a leap year, 2100 is not, and 2000 was.

Should you include the end date?

This is the most common reason two people get different answers for the same dates. Simple subtraction counts the gap between the dates, so it leaves out one day. Adding 1 counts every day on the calendar, including both ends.

Monday 2 to Friday 6 March 2026 counted as 4 days exclusive and 5 days inclusive
The same week counts as 4 days or 5 days, depending on the method.
SituationMethodExample
Hotel nights, rentals by the nightEnd − startCheck in on the 2nd, out on the 6th: 4 nights
Deadlines, “in X days”End − startFrom today to a date 30 days away
Age or time since a dateEnd − startDays since you started a job
Events, leave, holidaysEnd − start + 1A conference from the 2nd to the 6th: 5 days
Day-by-day plans, challengesEnd − start + 1A 30-day challenge from the 1st to the 30th

If a contract or a form tells you how to count, follow its rule. Otherwise ask yourself: does the first day count as a full day? If yes, add 1.

Days between dates in Excel and Google Sheets

Spreadsheets store dates as numbers, so you can subtract them directly. Put the start date in A2 and the end date in B2, then use one of these formulas:

Cheat sheet of Excel and Google Sheets formulas for days between dates
Six formulas cover almost every date count.
GoalFormulaNotes
Days between=B2-A2Format the result cell as a number, not a date.
Days between (function)=DAYS(B2,A2)The end date comes first.
Count both days=B2-A2+1Inclusive count.
Whole months=DATEDIF(A2,B2,"m")Use “y” for years and “d” for days. The start date must come first.
Working days=NETWORKDAYS(A2,B2)Skips Saturdays and Sundays and counts both ends.
Working days without holidays=NETWORKDAYS(A2,B2,H2:H10)List the holiday dates in H2:H10.
Date after X working days=WORKDAY(A2,20)Returns the date 20 working days after A2.

A few things to watch:

  • DATEDIF is hidden. Excel keeps it for compatibility with old Lotus 1-2-3 files, so Excel doesn’t suggest it as you type. Type it in full. If the start date is later than the end date, it returns #NUM!.
  • Avoid the “MD” unit. Microsoft warns that DATEDIF with “MD” can return a negative, zero or wrong result.
  • Text is not a date. If a formula returns #VALUE!, the cell probably holds text that looks like a date. Re-enter it or use DATE(2026,3,1).
  • Custom weekends. If your weekend isn’t Saturday and Sunday, use NETWORKDAYS.INTL or WORKDAY.INTL.

How to count business days only

For delivery times, notice periods and project plans, you usually need working days, not calendar days. In the calculator, open From today, enter the number of days and tick Business days only (skips weekends).

Countdown tool showing that 20 business days from March 2, 2026 is Monday, March 30, 2026
20 business days from Monday 2 March 2026 lands on Monday 30 March.

The tool skips Saturdays and Sundays but not public holidays, because holidays differ from country to country. Add one day for each holiday that falls inside your period. In a spreadsheet, list the holidays and pass them to NETWORKDAYS or WORKDAY.

Counting vs adding: “20 business days from 2 March” (the date you reach) is a different question from “how many business days from 2 to 30 March”. NETWORKDAYS counts both ends, so it returns 21 for that range.

Common mistakes to avoid

  • Mixing up day and month. 03/06/2026 is 6 March in the US and 3 June in most other countries. Check how your device or spreadsheet reads dates.
  • Forgetting 29 February. A period that crosses February in a leap year has one extra day.
  • Assuming every month has 30 days. Months have 28 to 31 days, so “3 months” is not always 90 days.
  • Adding 1 twice. If your tool already includes the end date, don’t add 1 again.

Working with hours rather than days? See our guide on how to calculate hours worked with a lunch break.

Count the days between any two dates

Free, no sign-up. Pick two dates and get days, weeks, months and hours at once.

Frequently asked questions

How do I calculate the number of days between two dates?
Subtract the earlier date from the later one. Add 1 if you want to count both the start and the end day. A days-between calculator does this for you and handles leap years automatically.

Does “days between” include the start date?
Simple subtraction counts the start date but not the end date, which is the same as counting the nights in between. Add 1 to include both.

How many days are in a year?
A common year has 365 days and a leap year has 366. A leap year is divisible by 4, except century years not divisible by 400.

How many weeks are between two dates?
Divide the number of days by 7. For example, 121 days is 17 weeks and 2 days.

What date is 90 days from today?
Open the From today tab in the calculator and enter 90. It shows the exact date and the day of the week.

How do I count days in Excel without weekends?
Use =NETWORKDAYS(start,end). Add a range of holiday dates as a third argument to skip those too.

Why does Excel show a date instead of a number?
The result cell has a date format. Change the cell format to Number or General.

Working with dates exported from software or an API as long numbers? Read what a Unix timestamp is and how to convert it.

Sources

Similar Posts