Expressing a time span in several units at once helps with contracts, projects, ages and anniversaries. Hours and seconds include the clock times, so the count is exact to the minute.
How to use the Date to Date Calculator
- Start date
- Start time
- End date
- End time
Results update as you type, and every field accepts the units shown in its menu.
How it works
Enter the start date and time and the end date and time.
Inputs explained
| Field | What to enter |
|---|---|
| Start date | A date |
| Start time | A clock time (hours and minutes) |
| End date | A date |
| End time | A clock time (hours and minutes) |
What each result means
- Years = sign([Months])×floor(abs([Months])÷12)
- and months = sign([Months])×mod(abs([Months]), 12)
- and days = [End date] – addmonths([Start date], [Months])
- Total days = [End date] – [Start date] + ([End time] – [Start time])÷24
- Total weeks = [Total days]÷7
- Total hours = [Total days]×24
- Total minutes = [Total days]×1440
- Total seconds = [Total days]×86400
Formula
Duration = (end date + end time) − (start date + start time)
Years, months, days = whole calendar years and months, then remaining days
Worked example
Inputs: Start date: 2026-10-25; Start time: 00:00; End date: 2027-11-29; End time: 00:00.
Results: Years = 1; and months = 1; and days = 4; Total days = 400; Total weeks = 57.14; Total hours = 9,600; Total minutes = 576,000; Total seconds = 34,560,000.
Frequently asked questions
How many days from one date to another?
Subtract the dates; the total days are shown, including any part day from the times.
How many seconds are in a year?
31,536,000 in a common year and 31,622,400 in a leap year.
Why do months vary?
Calendar months have 28–31 days, so "months and days" depends on the actual dates.