Date calculator

Shows its working step by step, gives the same answer as Excel, Google Sheets, SQL, Python and JavaScript formulas, adds time of day and weekdays only, and takes dates in US or day-first order.

In short

A date calculator finds the time between two dates, or the date a set time away. Between 20 October and 25 December 2026 there are 66 days, which is 2 months and 5 days or 9 weeks and 3 days. This one also adds or subtracts, counts weekdays, gives week numbers and shows its working.

  • Shows its working
  • Excel and SQL formulas
  • Weekdays only
  • Copy summary
  • Runs in your browser

Private by design. Nothing you type is uploaded or saved. Add this tool to your phone or computer for one-tap access.

The date fields use your browser’s own order. This only changes how results are written.

Page last updated

How to use it

  1. Choose Between two dates, Add or subtract, Countdown or About a date.
  2. Pick the dates with the date fields. They show in your browser’s own order, so US readers see month first.
  3. For Between two dates, choose whether to count the end date, add times if you want hours and minutes, and read the answer in years, months and days, in total days, weeks and weekdays.
  4. For Add or subtract, enter years, months, weeks and days, and whether to add or subtract.
  5. Open Show the working to see each step, and the spreadsheet and code formulas to repeat the answer elsewhere.

How it calculates

Dates are plain calendar dates with no time zone, counted on the Gregorian calendar. The days between two dates is the difference of their day numbers. Years, months and days are found by adding whole months to the earlier date for as long as that does not pass the later date; when a month is shorter the date moves back to its last day, so 31 January plus one month is 28 February. The days left over are counted from there. Adding or subtracting applies years and months first, then weeks and days. Weekdays only counts Monday to Friday. Hours and minutes use the times you enter, with no time zone or daylight saving.

For example, from Tuesday, October 20, 2026 to Friday, December 25, 2026 is 66 days, which is 2 months, 5 days or 9 weeks and 3 days, with 49 weekdays counted from both ends. Thirty days after the first date is 2026-11-19. Adding one month to 31 January 2026 gives 28 February, because February is shorter. 1 January 2027 falls in ISO week 53 of 2026. The dates are made up; yours come from what you choose.

Who should use it

  • Anyone counting days to a deadline, a due date, a trip or an anniversary
  • People working out a date a number of days or months from now, such as a notice or warranty end
  • Spreadsheet and database users who want to check a date formula
  • Anyone who needs the weekday, week number or day of the year of a date

Who should not use this

  • Anyone who needs a legally binding date or deadline; how days are counted depends on the contract, court or authority, so confirm with it
  • Anyone who needs time zones or daylight saving; the tool works with calendar dates and plain clock times only
  • Anyone who needs public holidays taken out; use the working days calculator, which has holiday lists for several countries

Limitations

  • Dates run from year 1 to year 9999 on the Gregorian calendar, which is applied to the past as well. It does not give Julian-calendar dates for history before the countries that switched.
  • There are no time zones. Times of day are taken as written, so a period that crosses a daylight saving change is counted as if every day had 24 hours.
  • Weekdays only means Monday to Friday. For another weekend or for holidays use the working days calculator.
  • Different tools count years, months and days differently when a month end is involved. This tool’s method is described under How it calculates; a spreadsheet DATEDIF can give another answer for the same dates.
  • Hijri and other calendars are not covered; use the Hijri date converter for those.
  • Nothing is uploaded or stored on a server. Clearing your browser data also removes the saved profile.

Sources and review

Reviewed on 20 Oct 2026 against the published sources below. Rules and prices change, so check the current position before you rely on a figure.

Common questions

How many days are there between two dates?
Subtract the earlier date from the later. From 20 October 2026 to 25 December 2026 is 66 days, because October has 11 days left after the 20th, November has 30 and December adds 25. Tick Count the end date as well to include both ends, which gives 67.
How do I add days to a date?
Choose Add or subtract, enter the date and the number of days, and the result is shown with its weekday. For example 30 days after 20 October 2026 is 19 November 2026. You can add years, months and weeks at the same time.
How are months counted when a date is at the end of a month?
When the later month is shorter, the date moves back to its last day. 31 January plus one month is 28 February (29 in a leap year), and 29 February plus one year is 28 February. This is the usual rule and matches most calendars and databases, but a few tools do it differently.
Is the end date counted?
By default it is not: the answer is the difference, so today to tomorrow is 1 day. Many people mean “inclusive” for a stay or a project, where both the first and last day count. Tick Count the end date as well and one day is added.
How do I count weekdays or business days between two dates?
The result shows the weekdays (Monday to Friday) between your two dates, both ends included. That does not remove public holidays. The working days calculator lets you set your own weekend and add holidays for the US, UK, Pakistan, the Gulf and India.
What week number is a date in?
About a date gives the ISO week: weeks start on Monday and week 1 is the week with the year’s first Thursday. So 1 January 2027, a Friday, is in week 53 of 2026. The US calendar often numbers weeks differently, starting on Sunday, so check which system you need.
How do I calculate the days between dates in Excel or Google Sheets?
Subtract the cells: with dates in A1 and B1, =B1-A1 gives the days. DATEDIF(A1,B1,"d") gives the same, and NETWORKDAYS(A1,B1) gives the weekdays. The page shows the formulas for your dates, along with SQL, Python and JavaScript versions.
Does it handle leap years?
Yes. A year is a leap year if it divides by 4, except centuries not divisible by 400, so 2024 and 2000 were leap years and 1900 and 2100 are not. February has 29 days in a leap year, and the day counts and the month arithmetic both allow for it.
How do I find the days until a date?
Choose Countdown, enter the date, and the tool compares it with today’s date on your device. It shows the days left or, if the date has passed, the days since, with the weeks and weekdays as well.

Guides that explain the rules

Related tools

This tool produces a document from the information you type. It does not give legal, tax or accounting advice, and it does not check that your figures or rates are right. See the disclaimer. Found a mistake? Report an error in a calculation.