Date to date calculator with a calendar icon on a dark background

Date to Date Calculator: Duration Between Dates

Last updated:

Use this free date to date calculator to find the exact number of days, weeks, months and years between any two dates. Enter a start date and an end date, press Calculate, and get your answer in seconds. Leap years and different month lengths are handled for you.

Enter two dates and press Calculate.
Enter a date and an amount, then press Calculate.

exemple

1. Days between dates. January 15, 2024 to March 20, 2024 is 65 days: 31 days to February 15, 29 days to March 15 (2024 is a leap year) and 5 more days. That is 0 years, 2 months and 5 days, or 9 weeks and 2 days. It contains 47 working days and 18 weekend days. Excluding two US federal holidays (Martin Luther King Jr. Day on January 15 and Presidents’ Day on February 19) leaves 45 working days. Counting the end date as well gives 66 days.

2. Add days to a date. January 15, 2024 plus 90 days is Sunday, April 14, 2024.

Working days and weekend days cover the same range as the day count. Months are counted by adding whole months to the start date and then counting the remaining days. Dates from 1583 to 9999 are supported, using the Gregorian calendar.

Quick answer: To find the number of days between two dates, subtract the earlier date from the later one. For example, March 3, 2026 to March 18, 2026 is 15 days, or 16 days if you count both the first and last day.

How to Use the Date to Date Calculator ?

  1. Pick your start date. Type the date or choose it from the calendar. Click Today to enter the current date.
  2. Pick your end date. This is the date you want to measure to. It can be in the past or in the future.
  3. Choose your options. Tick Include the end date in the count if both the first and last day should be counted, such as for leave, bookings or events. Tick Exclude US federal holidays from working days to remove them from the working day count.
  4. Press Calculate. You get the total days, the difference in years, months and days, weeks and days, and the number of working days and weekend days. Press Reset to start again.

Need a future or past date instead of a gap? Open the Add or subtract tab, enter a start date, choose Add or Subtract, type an amount in days, weeks, months or years, and press Calculate.

How Many Days Are Between Two Dates?

To find the number of days between two dates, subtract the earlier date from the later date. The result is the number of days that have passed from one to the other.

Days between two dates = End date − Start date

The result depends on whether you count the end date. Counting only the time that passes gives the first number. Counting both the first and last day adds one.

Start dateEnd dateDays betweenCounting both dates
March 3, 2026March 18, 20261516
January 1, 2026February 1, 20263132
February 10, 2026March 10, 20262829
January 1, 2026July 4, 2026184185
January 1, 2026December 31, 2026364365
February 1, 2024March 1, 20242930
January 1, 2024January 1, 2025366367

Counting by hand gets harder as the range grows, because months have 28, 29, 30 or 31 days, and a leap year adds an extra day. Our date to date calculator above handles both automatically, so you can check any range in seconds.

Should You Include the End Date?

It depends on what you are measuring. The date to date calculator gives you both answers, and the Include the end date in the count option switches between them.

Leave the end date out when you are measuring time that has passed or time that remains:

  • How old someone is. A person born on June 15, 2000 is exactly 26 years old on June 15, 2026.
  • How long a subscription, project or job has been running.
  • How many days are left until a deadline, trip or event.

Include the end date when both the first and the last day count:

  • Leave and time off. Monday, January 5 to Friday, January 9 is 5 days off, not 4.
  • Events and courses. A conference that runs from March 10 to March 12 lasts 3 days.
  • Periods written as “from X to Y inclusive”, which are common in contracts and rental agreements.

Hotel stays are a special case. If you check in on Monday and check out on Friday, you pay for 4 nights, even though you are there on 5 calendar days. For nights, leave the end date out.

What you are countingInclude the end date?Example
Age or anniversaryNoJune 15, 2000 to June 15, 2026 = 26 years
Days until an event or deadlineNoMarch 3 to March 18 = 15 days
Days since a dateNoElapsed time only
Leave or time offYesJan 5 to Jan 9 = 5 days
Length of an event or courseYesMarch 10 to March 12 = 3 days
Hotel or rental nightsNoMon to Fri = 4 nights
Contract or notice periodCheck the wordingLook for “inclusive” or “from the date of”

When a contract or legal document sets a deadline, read how it counts the days, because the rules differ between documents and places. If you are unsure, run the calculation both ways and compare.

How to Calculate the Number of Days Between Two Dates by Hand

You can count the days yourself without a calculator. The easiest method uses day-of-year numbers, where January 1 is day 1 and December 31 is day 365 (or 366 in a leap year). Because the leap day is already built into these numbers, you never have to add it separately.

Step 1: Find the day-of-year number of each date. Add up the days in all the months before it, then add the day of the month. For a normal year, these are the totals at the end of each month:

MonthTotal days by month end
January31
February59
March90
April120
May151
June181
July212
August243
September273
October304
November334
December365

In a leap year, add 1 to every total from February onward.

Step 2: Subtract. The method depends on whether the dates fall in the same year.

Both dates in the same year

Subtract the smaller day number from the larger one.

Example: April 12, 2026 to September 25, 2026. April 12 is day 90 + 12 = 102. September 25 is day 243 + 25 = 268. The difference is 268 − 102 = 166 days.

Dates in different years

  1. Find the days left in the start year: the length of the year minus the start date’s day number.
  2. Add 365 (or 366) for every full year in between.
  3. Add the end date’s day number.

Example: November 20, 2025 to May 8, 2026. November 20, 2025 is day 304 + 20 = 324, so 365 − 324 = 41 days remain in 2025. There are no full years in between. May 8, 2026 is day 120 + 8 = 128. The total is 41 + 128 = 169 days.

Hand counting works well for short ranges, but it is easy to slip over several months or years. For longer ranges, use the date to date calculator above.

Weeks, Months and Years Between Two Dates

Once you know the total number of days, the other units follow. The date to date calculator shows all of them at once.

Weeks. Divide the total days by 7. The whole number is the number of weeks, and the remainder is the extra days. For example, 100 days is 14 weeks and 2 days.

Hours, minutes and seconds. Multiply the days by 24 for hours, by 1,440 for minutes and by 86,400 for seconds. For 100 days, that is 2,400 hours, 144,000 minutes and 8,640,000 seconds.

Years. The exact answer is the number of full anniversaries. For a quick estimate, divide the days by 365.25. For example, March 10, 2020 to March 10, 2026 is 2,191 days, and 2,191 ÷ 365.25 is about 6.0, which matches the exact answer of 6 years.

Why Months Are the Tricky Part

A month can be 28, 29, 30 or 31 days long, so there is no single correct way to count them. Different date calculators can give slightly different month and day results for the same dates, especially at the end of a month.

Our calculator uses a simple rule: it adds whole months to the start date, then counts the days that remain. When the start date does not exist in a month (for example, the 31st in a 30-day month), it uses that month’s last day.

Start dateEnd dateResultTotal days
January 15, 2026March 15, 20262 months, 0 days59
May 31, 2026July 1, 20261 month, 1 day31

In the second example, May 31 plus one month lands on June 30, and July 1 is one more day. The total day count is always exact, so if the month breakdown looks unusual, check the days figure.

How Leap Years and Month Lengths Affect the Count

A normal year has 365 days. A leap year has 366, because February gets an extra day, February 29. Forgetting that day is one of the most common mistakes in manual date math. The calculator accounts for it automatically.

The leap year rule:

  • A year divisible by 4 is a leap year (2028, 2032).
  • Except years divisible by 100, which are not (1900, 2100).
  • Unless they are also divisible by 400, in which case they are (2000, 2400).

How it changes the result:

Start dateEnd dateDays between
February 1, 2026March 1, 202628
February 1, 2028March 1, 202829
January 1, 2028January 1, 2029366

The same date range gives a different answer depending on whether it crosses a February 29.

How long is each month?

  • 31 days: January, March, May, July, August, October, December
  • 30 days: April, June, September, November
  • 28 or 29 days: February (29 in a leap year)

The calculator uses the Gregorian calendar, the calendar used in most of the world today, and supports dates from the year 1583 to 9999.

Calendar Days vs Business Days

Calendar days include every day between two dates, weekends and holidays too. Business days, also called working days, usually mean Monday to Friday only. The date to date calculator shows both, so you can compare them side by side.

Example: Monday, November 2, 2026 to Friday, November 27, 2026, counting both dates.

CountResult
Calendar days26
Working days (Monday to Friday)20
Weekend days6
Working days, excluding US federal holidays18

Two US federal holidays fall inside this range: Veterans Day on Wednesday, November 11, and Thanksgiving on Thursday, November 26. Tick Exclude US federal holidays from working days and the calculator removes them from the count.

Why the difference matters:

  • Work deadlines and project schedules
  • Delivery and shipping estimates
  • Notice periods and probation periods
  • Payment terms, such as “net 30” versus “30 business days”
  • Processing times for banks, visas and government applications

Keep in mind:

  • Federal holidays are not the same as bank, state, school or company holidays. If your calendar has other days off, subtract them yourself.
  • If a holiday falls on a weekend, the day off is sometimes moved to a Friday or Monday. Check the rules of your employer or agency.
  • Always check whether a document means calendar days or business days. When it does not say, assume calendar days.

How to Calculate the Difference Between Two Dates in Excel and Google Sheets

If your dates are already in a spreadsheet, a few formulas do the same job. These work in both Excel and Google Sheets. Put the start date in cell A1 and the end date in cell B1.

What you wantFormula
Days between the dates=B1-A1 or =DAYS(B1,A1)
Days, counting both dates=B1-A1+1
Full years between the dates=DATEDIF(A1,B1,"y")
Full months between the dates=DATEDIF(A1,B1,"m")
Working days (Monday to Friday)=NETWORKDAYS(A1,B1)
Working days, excluding holidays=NETWORKDAYS(A1,B1,D1:D10)

Example: with January 15, 2024 in A1 and March 20, 2024 in B1, the formulas return 65 days, 66 days counting both dates, 0 full years, 2 full months and 48 working days.

Things to know:

  • NETWORKDAYS counts both the start and the end date. That is why it returns 48 here, while our calculator shows 47 working days when the end date is not included.
  • The holiday list in the third argument is a range of cells that contain dates, such as D1:D10.
  • If a day formula shows a date instead of a number, format the cell as Number or General.
  • For a custom weekend, such as Friday and Saturday, use NETWORKDAYS.INTL.
  • DATEDIF does not appear in Excel’s formula suggestions, but it works. Avoid its "MD" option, which is known to return wrong results in some cases.
  • Month results can differ slightly from our calculator at the end of a month, because spreadsheets and calculators count months in different ways.

For a one-off answer, the date to date calculator above is faster than building a formula, and it shows weeks, months and working days at the same time.

When to Use a Date to Date Calculator

Use it any time you need to know how much time sits between two dates. Here are the most common situations, and the settings that fit each one.

Counting down to an event. Enter today’s date as the start and the event date as the end. From December 1, 2026 to December 25, 2026 is 24 days. Leave the end date out, since you want the time that remains.

Counting days since something happened. Enter the past date as the start and today as the end. Click Today to fill the current date. This works for an anniversary, a habit streak, or how long ago you started a job.

Measuring how long a project or event lasted. Enter the first and last day and tick Include the end date. A project that runs from Monday, January 4, 2027 to Friday, January 29, 2027 lasts 26 calendar days, which is 20 working days.

Planning leave or time off. Include the end date and look at the working days result, since weekends are not usually counted as leave.

Checking payment terms and due dates. To find a due date, open the Add or subtract tab. An invoice dated March 3, 2026 with 30-day terms is due on Thursday, April 2, 2026. Remember that “30 days” and “30 business days” are different deadlines.

Working out notice or probation periods. Calculate the end date with the Add or subtract tab, then check your contract for how the days are counted.

Comparing two historical dates. Enter both dates to see how many years, months and days separate them. The calculator supports dates from 1583 to 9999.

Finding the length of a school term or course. Enter the first and last day, include the end date, and compare calendar days with working days.

Frequently Asked Questions

How do I calculate the number of days between two dates?

Subtract the earlier date from the later one. For example, March 3, 2026 to March 18, 2026 is 15 days. For longer ranges, enter both dates in the calculator above and press Calculate. It handles month lengths and leap years for you.

How do I find the number of days from today to a date?

Click Today next to the start date, enter your target date as the end date, and press Calculate. The result updates to the current date every time you use it.

Does the calculator include the end date?

Not by default. It counts the days that pass between the two dates. Tick Include the end date in the count to count both the first and the last day, which adds one day to the total.

How many working days are between two dates?

The calculator shows working days (Monday to Friday) and weekend days for every range. Tick Exclude US federal holidays from working days to remove federal holidays from the working day count. Company, bank and state holidays are not included.

How do I add days to a date or subtract them?

Open the Add or subtract tab, enter a start date, choose Add or Subtract, and type an amount in days, weeks, months or years. For example, January 15, 2024 plus 90 days is Sunday, April 14, 2024.

Does the calculator account for leap years?

Yes. It uses the Gregorian calendar and adds February 29 in leap years such as 2024 and 2028. It supports dates from 1583 to 9999.

Why does my result differ from another date calculator?

The total number of days should match. Small differences usually come from three things: whether the end date is counted, how months are counted at the end of a month, and whether the other tool includes the time of day. Our calculator adds whole months to the start date and then counts the remaining days.

Is the date to date calculator free?

Yes. It is free to use, and you do not need to sign up.

Scroll to Top