Date Calculator
Some date jobs are too small to open a spreadsheet for and too easy to miscount by hand. This date calculator does the three jobs people reach for most: the number of days between two dates, the date a set number of days after a start date, and the date a set number of days before one. It counts plain calendar days, weekends included, handles leap years on its own, and reads the span back in weeks and approximate months and years at the same time. If you would rather do the same job inside a workbook, the section further down, “Doing this in Excel instead?”, gives the exact formula for each mode. Calculator Zilo is not affiliated with Microsoft or Excel; the tool below is a standalone date calculator, and Excel is covered in a dedicated formula section and in the formula help inside the FAQs, with further formula notes where they are genuinely relevant elsewhere on the page.
Quick Answer
From January 1, 2026 to March 15, 2026 is 73 days: 10 weeks, 2 months on the tool's 30-day-month reading, or a breakdown of 0 years, 2 months, 13 days. Switch the mode and the same start date plus 90 days lands on Wednesday, April 1, 2026.
Key takeaways
- Date arithmetic is simple once the calendar is handled for you: days between dates is one date minus the other, and adding days shifts one date forward. This tool does that calendar handling, leap years included.
- The start date is not counted. January 1 to January 5 is 4 days here; add 1 if your context counts both endpoints.
- The breakdown uses 365-day years and 30-day months, so it is an approximation. A calendar-accurate breakdown counts complete calendar months first, and the two can differ by a day.
- Dates are handled as calendar dates, not timestamps, so the result date and its ISO form always agree, in every timezone.
- Quick Answer
- How to use this date calculator
- The arithmetic behind each mode
- Worked examples: a 73-day span and a 90-day deadline
- Read the months and years figures as approximations
- Doing this in Excel instead?
- Why a date result can shift by a day, and why this one does not
- Counting conventions: which days are included
- This tool or a spreadsheet: an honest comparison
- What competing calculators miss
How to use this date calculator
Pick a mode first, because the mode decides which inputs appear. The results stay hidden until you click Calculate.
- Date Difference: enter a start date and an end date. You get the total days, the same span in whole weeks, an approximate months and years reading, and a years, months, days breakdown.
- Add Days to Date: the end date field is replaced by a Number of Days field. Enter a start date and a whole number of days to land on the future date, shown in long form and in ISO format (YYYY-MM-DD).
- Subtract Days from Date: the same layout, moving the start date backward. Use it for "30 days before the deadline" questions.
Two behaviours worth knowing before you rely on a result. The day count is absolute, so entering the end date before the start date in Difference mode returns the same number rather than a negative or an error. And the days field truncates decimals: 10.9 is treated as 10, exactly as the original tool handled it.
The arithmetic behind each mode
Every mode is one line of arithmetic. The tool counts calendar days between the two dates, or shifts one date by a whole number of days. The formula box states both jobs exactly as the code runs them.
Result date = Start date + Days (Add) or Start date − Days (Subtract)
Worked examples: a 73-day span and a 90-day deadline
The pre-filled dates are a project that starts on January 1, 2026 and ends on March 15, 2026. Run in Difference mode, the tool reports the span four ways:
| Check | Mode | Result |
|---|---|---|
| Feb 1, 2024 to Mar 1, 2024 (leap year) | Difference | 29 days, 4 weeks, breakdown 0 years, 0 months, 29 days |
| Same day to same day | Difference | 0 days, 0 weeks, 0 months, 0.00 years |
| January 1, 2026 plus 90 days | Add | Wednesday, April 1, 2026 (ISO 2026-04-01) |
| March 15, 2026 minus 30 days | Subtract | Friday, February 13, 2026 (ISO 2026-02-13) |
| February 28, 2024 plus 1 day | Add | Thursday, February 29, 2024 (ISO 2024-02-29) |
Each row is a real run of this calculator, and the leap-year rows are the ones worth testing any date tool against: February 2024 has 29 days, so the February span counts 29 and February 28 plus one day lands on the 29th, not March 1. For payroll-flavoured spans, the days between pay periods calculator applies the same kind of gap to pay cycles, and the billable days calculator handles the working-day version of the count.
Read the months and years figures as approximations
The total days figure is exact. The months and years readings are conversions, and the tool is explicit about the conversion it uses: total months is the day count divided by 30 (floored), total years is the day count divided by 365 (two decimals), and the breakdown peels off whole 365-day years, then whole 30-day months, then the remaining days.
That is why the worked example breaks 73 days down as 2 months and 13 days, while a calendar-accurate breakdown for the same dates is 2 months and 14 days: it counts two complete calendar months (January 1 to March 1) and then the 14 remaining days of March. Excel's DATEDIF function, covered in the spreadsheet section below, produces that calendar-accurate version. Neither is a bug. They answer slightly different questions, an approximate unit conversion versus a calendar-accurate split, and for spans where the distinction matters (tenancy, probation periods, age), use the calendar-accurate version.
Doing this in Excel instead?
The same three jobs take one formula each in a spreadsheet, because Excel stores dates as serial numbers: subtracting two date cells gives the elapsed days, and adding a number to a date cell shifts the date. This page is not affiliated with Microsoft or Excel, and the calculator above is not an Excel tool; this section is here for readers who need the answer inside a workbook rather than on a web page.
| Job | Spreadsheet formula | Notes |
|---|---|---|
| Days between two dates | =B2-A2 or =DAYS(B2,A2) | Format the result cell as a number, not a date. DAYS takes the end date first. |
| Calendar breakdown (years, months, days) | =DATEDIF(A2,B2,"Y"), "YM", "MD" | Calendar-accurate complete years, months and days. DATEDIF is documented by Microsoft but does not appear in formula autocomplete. |
| Add days to a date | =A2+90 | Keep the result cell formatted as a date or Excel shows the serial number. |
| Subtract days from a date | =A2-30 | Negative results before January 1, 1900 show as #### in the 1900 date system. |
| Add months (spreadsheet only) | =EDATE(A2,3) | This tool adds days only. For month shifts in a workbook, EDATE lands on the same day of the target month, clamping to the month's last day when needed. |
| Working days (spreadsheet only) | =NETWORKDAYS(A2,B2), =WORKDAY(A2,30) | This tool counts calendar days, weekends included. NETWORKDAYS counts weekdays between dates and WORKDAY moves by working days; both accept a holiday list as an extra argument. |
The full list of functions lives in Microsoft's date and time functions reference, which is the authoritative syntax source for every formula in the table. If you are costing a loan schedule in a workbook rather than counting days, the excel auto loan calculator and the excel car payment calculator cover the spreadsheet payment side of the same family.
Why a date result can shift by a day, and why this one does not
A date-only string such as 2026-01-01 is parsed as midnight UTC by JavaScript, a behaviour MDN's Date.parse documentation spells out. Tools that then read that timestamp back in local time show the previous day to every visitor west of UTC, and their long-form date and ISO date can disagree with each other in the same result box. It is the most common date-calculator bug on the web, and it never shows up for the developer testing in UTC or east of it.
This calculator avoids the trap by splitting the date into year, month and day and working with those calendar parts directly, the same way spreadsheet serial numbers sidestep timezones entirely. The answer for January 1, 2026 plus 90 days is Wednesday, April 1, 2026 whether you run it in New York, Karachi or Auckland, and the long date and the ISO date in the result are two formats of the same day. Date-and-time tools that do work with timestamps, such as the duration calculators timeanddate documents in its help pages, have to handle the timezone question head-on; a calendar-day tool should never inherit it.
Counting conventions: which days are included
The tool counts elapsed days, so the start date itself is day zero and is not counted. January 1 to January 5 is 4 days, matching plain date subtraction and the convention behind most deadline language ("within 30 days of January 1" ends on January 31, which is exactly what Add mode returns for 30 days).
If your context counts both endpoints, a hotel stay billed per night versus a conference pass sold per day, add 1 to the Difference result. If your context counts working days only, this is the wrong tool and the wrong formula: use the NETWORKDAYS or WORKDAY formulas from the spreadsheet section above, or a working-day calculator, because no setting here excludes weekends or holidays.
This tool or a spreadsheet: an honest comparison
Use this calculator when
- You need one gap or one deadline date now, on any device.
- You want the span read back in weeks and approximate months at the same time.
- There is no workbook to build the answer into.
Use a spreadsheet when
- You need working days, holidays, or custom weekends (NETWORKDAYS, WORKDAY).
- You need month or year shifts (EDATE) or a calendar-accurate breakdown (DATEDIF).
- The date math feeds a larger model, schedule or invoice run.
What competing calculators miss
Date tools are a crowded field, and the gaps are consistent across the top results:
- timeanddate: the deepest feature set, with years, months, weeks and days in Add mode, business-day variants and repeat calculations. The cost is complexity: separate calculators for duration and add/subtract, settings screens, and results split across pages where this page keeps all three modes in one card.
- calculations.tools and Calculator Park date calculators: strong all-rounders with business-day modes and good spreadsheet formula tables. Their inclusive/exclusive counting toggles are genuinely useful; calculations.tools also breaks the span down by complete calendar months, which this tool does not.
- Spreadsheet tutorials (Spreadsheet Planet, ExcelDemy, DashboardsExcel): excellent formula teaching, DAYS, DATEDIF, NETWORKDAYS and EDATE all covered, but the formula is the product: you still have to open a workbook and build the cell yourself for a one-off answer.
- The gap this page fills: the three everyday jobs in one tool, the approximation behind the months and years figures stated in plain language instead of hidden, the spreadsheet formula for each job for readers who need it in a workbook, and date handling that cannot drift by a day with the reader's timezone.
Frequently asked questions
Enter the start date and the end date in Date Difference mode: the tool subtracts one date from the other and returns the elapsed calendar days, plus weeks and approximate months and years readings. In a spreadsheet the same job is one subtraction, =B2-A2, because Excel stores dates as serial numbers; the =DAYS(B2,A2) function does the same job with the end date first.
No. It counts calendar days, weekends included, and it has no holiday list. For working days in a spreadsheet, Excel's =NETWORKDAYS(A2,B2) counts working days between two dates and =WORKDAY(A2,30) moves forward by working days; both accept a range of holiday dates as an extra argument.
Because the two use different month definitions. This tool's breakdown peels off whole 30-day months from the day count, so 73 days becomes 2 months and 13 days. A calendar-accurate breakdown, such as Excel's DATEDIF, counts complete calendar months first (January 1 to March 1) and then the remaining calendar days, giving 2 months and 14 days for the same span. The total of 73 days is identical either way.
Not in this tool: Add and Subtract modes move by whole days only. In Excel, use =EDATE(A2,3) to move a date by months, which lands on the same day of the target month and clamps to the last day of the month when the target month is shorter. Adding 365 days is not the same as adding a year across a leap day.
The count is elapsed days: the start date is not counted, the end date is the point you arrive at. January 1 to January 5 returns 4 days, the same as plain date subtraction. If you need both endpoints counted, for example days attended rather than nights elapsed, add 1 to the result.
The tool reports the absolute gap, so March 15 to January 1 returns the same 73 days as January 1 to March 15. There is no negative result and no error. In a spreadsheet, plain subtraction returns a negative number for the reversed order, so wrap it in ABS if you want the same behaviour in a workbook.
No. The calculator splits each date into year, month and day and does calendar arithmetic on those parts, so the result is identical in every timezone and the long-form date always matches the ISO date shown with it. Tools that parse a date-only string as a UTC timestamp can show the previous day to visitors west of UTC; this one is built to avoid that.
The days field treats 0, a blank field and a non-number the same way: as no input, and it asks you to enter a number of days. That is the tool's original validation behaviour, kept as is. Adding zero days would return the start date itself, so if you need that answer, it is simply the start date you entered.
Add This Calculator to Your Website
Embed this calculator on your own site with the code below. Pick a size to preview it live, then copy the code.
Powered by Calculator Zilo
References
- Microsoft Support. Date and time functions (reference). Accessed October 21, 2026.
- Mozilla Developer Network. Date.parse(): date-only strings are interpreted as UTC. Accessed October 21, 2026.
- Mozilla Developer Network. Date.prototype.toDateString(): local timezone interpretation. Accessed October 21, 2026.
- Microsoft Support. DATEDIF function. Accessed October 21, 2026.
- Google Docs Editors Help. DATEDIF function in Google Sheets. Accessed October 21, 2026.
- Microsoft Support. Calculate days between dates or calculate a future or past date (Windows Calculator). Accessed October 21, 2026.