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:
- Open the tool and choose the Between tab.
- Pick the Start date and the End date.
- Tick Include the end date if both days should count.
- Read the answer in days, plus weeks and days, months and days, and hours.

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:
- Days left in the first month. Subtract the start day from the length of that month.
- Full months in between. Add the length of each whole month.
- Days in the last month. Add the end day.
Example: 1 March to 30 June 2026.
| Part | Calculation | Days |
|---|---|---|
| Rest of March | 31 − 1 | 30 |
| April | Full month | 30 |
| May | Full month | 31 |
| June | Up to the 30th | 30 |
| Total | 121 |
Days in each month
| Month | Days | Month | Days |
|---|---|---|---|
| January | 31 | July | 31 |
| February | 28 (29 in a leap year) | August | 31 |
| March | 31 | September | 30 |
| April | 30 | October | 31 |
| May | 31 | November | 30 |
| June | 30 | December | 31 |
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.

| Situation | Method | Example |
|---|---|---|
| Hotel nights, rentals by the night | End − start | Check in on the 2nd, out on the 6th: 4 nights |
| Deadlines, “in X days” | End − start | From today to a date 30 days away |
| Age or time since a date | End − start | Days since you started a job |
| Events, leave, holidays | End − start + 1 | A conference from the 2nd to the 6th: 5 days |
| Day-by-day plans, challenges | End − start + 1 | A 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:

| Goal | Formula | Notes |
|---|---|---|
| Days between | =B2-A2 | Format 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+1 | Inclusive 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).

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.