You need the exact number of days between two dates — for a deadline, contract, or project plan. Here are two methods: the free calculator (instant, accurate) and the manual approach (when you do not have internet access).
Enter two dates — get days, weeks, months, business days. Instant.
Open Date CalculatorHandles leap years, month lengths, and year boundaries automatically. Zero errors.
Count remaining days in start month + full months + days in end month:
Example: January 15 to March 10
| Calculation | Excel / Google Sheets Formula | Result |
|---|---|---|
| Total days | =B1-A1 | Number of days |
| Business days | =NETWORKDAYS(A1,B1) | Weekdays only |
| Months | =DATEDIF(A1,B1,"m") | Full months |
| Years | =DATEDIF(A1,B1,"y") | Full years |
| Remaining days after months | =DATEDIF(A1,B1,"md") | Extra days |
| Trap | Example | Correct Answer |
|---|---|---|
| Different month lengths | Jan 31 + 30 days = ? | March 2 (not Feb 30) |
| Leap year | Feb 28, 2024 + 1 day = ? | Feb 29 (leap year) |
| Year boundary | Dec 25 + 14 days = ? | January 8 next year |
| Business days ≠ calendar | 10 business days = ? | 14 calendar days |
| February varies | Days in Feb = ? | 28 or 29 depending on year |
Skip the manual math — get exact day counts instantly.
Open Date Calculator