Tools

Days between two dates calculator

The exact number of days, weeks and months between two dates. Nothing you type leaves your browser.

Calculate
Dates are read on your own calendar, so time zones and clock changes never move a result.
Days between
0days
Pick two dates

Calendar days, including weekends and holidays. For working days only, use the business days calculator.

How to use the days between dates calculator

  1. Days between two dates: enter a start date and an end date. You get the duration in days, the same span in weeks and days, and in years, months and days.
  2. Add or subtract days: switch to Add or subtract days, pick a start date (today is filled in for you) and enter a number of days or weeks. The quick picks fill in 30, 60, 90, 180 or 365 days, so "90 days from today" is one click.

Start from today puts today's date in the start box, in either mode. For "how many days until" a date, enter that date as the end date. For "how many days ago" something happened, enter the past date as the end date: the calculator counts back and tells you the end date is earlier. "30 days ago" is Add or subtract days with Subtract and 30. Tomorrow is today plus 1 day and yesterday is today minus 1 day, so from Wednesday, October 7, 2026, tomorrow is Thursday, October 8 and yesterday was Tuesday, October 6.

Results update as you type, and Copy result puts a one-line answer on your clipboard. Everything is worked out on your device.

How the days are counted

The calculator counts how many days you move forward to get from the start date to the end date. From Monday to the next Monday is 7 days. In other words, the start date is counted and the end date is not, which is the usual answer to "how many days until...".

Sometimes you want both dates counted, for example the length of a booking, a course or a leave period that includes its last day. Tick Count the end date as well and the result goes up by 1.

FromToDaysWith end date
Jan 1, 2026Dec 31, 2026364365
Oct 7, 2026Dec 25, 20267980
Feb 1, 2027Mar 1, 20272829
Feb 1, 2028Mar 1, 20282930

If the end date is earlier than the start date, the calculator counts the days back and tells you so, rather than showing a negative number.

Weeks, months and years

Weeks and days is the day count divided by 7: 79 days is 11 weeks and 2 days.

Years, months and days is less simple, because months have 28 to 31 days. The calculator counts a month each time the start date's day number comes round again, then counts the days left over. From October 7, 2026 to December 25, 2026 is 2 months (to December 7) and 18 days.

When the start day does not exist in a month, the last day of that month stands in for it. From January 31, 2027 to February 28, 2027 is exactly 1 month, and to March 1, 2027 it is 1 month and 1 day. With the end date counted, a full calendar year such as January 1 to December 31, 2026 shows as exactly 1 year.

Working out someone's age: the years, months and days line is the usual way to state an age. Enter the date of birth as the start date and today as the end date, and leave Count the end date as well unticked. Someone born on May 15, 1990 is 36 years, 4 months and 22 days old on October 7, 2026. For a February 29 birthday, February 28 stands in for it in years without a leap day.

Days between dates in Excel or Google Sheets

Spreadsheets store each date as a count of days, which is why you can subtract one date from another. Microsoft explains that "By default, January 1, 1900 is serial number 1". With the start date in A2 and the end date in B2, these formulas work in both Excel and Google Sheets:

To getFormulaSame as this calculator
Days between two dates=B2-A2 or =DAYS(B2,A2)Start date counted, end date not
Days with both dates counted=B2-A2+1Count the end date as well, ticked
A date plus the days in B2=A2+B2Add or subtract days
Days from today until B2=B2-TODAY()Start from today
Whole years, then months left over=DATEDIF(A2,B2,"Y"), =DATEDIF(A2,B2,"YM")The years and months in Years, months, days, except as noted below

DAYS takes the end date first: Microsoft gives the syntax as DAYS(end_date, start_date), and its example =DAYS("15-MAR-2021","1-FEB-2021") returns 42, the same answer this calculator gives for February 1 to March 15, 2021. Google's example =DAYS("7/24/1969", "7/16/1969") returns 8. To add days, Microsoft says to enter =A2+B2 and that "You can enter a negative number to subtract days from your start date". Format a day count as a number and an added date as a date, or the cell may show the wrong kind of value.

DATEDIF with "Y" gives "The number of complete years in the period", and Microsoft notes it "is useful in formulas where you need to calculate an age". Be careful with the "MD" unit for the leftover days: Microsoft warns it "may result in a negative number, a zero, or an inaccurate result."

DATEDIF and this calculator differ in one case: when the start day is missing from the end month, such as the 31st or a February 29 birthday. Google says months and years are "only counted if they are equal to or go past the 'day'", so DATEDIF waits for the same day number, while this calculator lets the month's last day stand in. January 31 to February 28, 2027 is 1 month here and 0 months in DATEDIF.

Leap years

February has 29 days in a leap year, so any span that crosses February 29 is one day longer. The calculator uses the Gregorian calendar rule, as the US Naval Observatory states it:

"Years evenly divisible by 4 are leap years, with the exception of centurial years that are not evenly divisible by 400."US Naval Observatory, Astronomical Applications

So 2028 is a leap year, 2100 is not, and 2000 was. That is why February 1 to March 1 is 28 days in 2027 but 29 days in 2028.

Adding and subtracting days

Adding days moves forward that many calendar days, weekends and holidays included. Subtracting moves back. Weeks are 7 days each. Here is what the quick picks give from Wednesday, October 7, 2026:

From Oct 7, 2026Date
30 days laterFriday, November 6, 2026
60 days laterSunday, December 6, 2026
90 days laterTuesday, January 5, 2027
180 days laterMonday, April 5, 2027
365 days laterThursday, October 7, 2027
90 days earlierThursday, July 9, 2026

Notices and contracts sometimes say how to count a period, for example whether the first day counts or what happens when the last day is a weekend. If a deadline matters, follow the wording of the document. To skip weekends and public holidays, use the business days calculator.

Questions and answers

How many days from now is a date?

Press Start from today so today is the start date, then enter the date you want: the result counts the days from now until then, like a simple day counter. For a date in the past, the result is the number of days ago.

How do I count the days between two dates in Excel?

Subtract the earlier date from the later one, =B2-A2, or use =DAYS(B2,A2) with the end date first. Both count the start date and not the end date, as this calculator does. Add 1 to count both dates. The same formulas work in Google Sheets.

What is 90 days from today?

Open Add or subtract days, which starts from today, and press 90 days. From October 7, 2026, for example, 90 days later is Tuesday, January 5, 2027.

Does the count include the start date or the end date?

It counts the days from the start date to the end date, so Monday to the next Monday is 7 days. Tick "Count the end date as well" to include both dates, which adds 1.

How many days are there between two dates in different years?

Enter both dates and the calculator counts every day between them, including February 29 in leap years. January 1, 2026 to January 1, 2027 is 365 days.

Why does the months figure look odd near the end of a month?

Months have different lengths. A month is counted when the start day number comes round again, and the last day of a shorter month stands in for a day it does not have. So January 31 to February 28, 2027 counts as 1 month: February has no 31st, so its last day takes that place. January 31 to February 27 is 27 days.

Can a time zone or daylight saving change the answer?

No. The calculator works with calendar dates only, never clock times, so a clock change or your time zone cannot add or remove a day. Today is taken from your own device.

Sources

Checked on 7 October 2026. If a rule has changed, please tell us.

More dates tools

All dates tools