Home › Date Duration: Years, Months, and Days Explained
Date Duration: Years, Months, and Days Explained
By The Editors, Encore Editorial, Updated June 21, 2026
A date duration is the complete breakdown of the span between two dates: full years, remaining months, and remaining days. This is more informative than a raw day count for employment records, age statements, and contractual terms. Use the date calculator for the day total, then the methods below to break it into years, months, and days.
Days vs. duration: when each is useful
The total day count (see how to calculate days between two dates) answers the question "how long exactly?" The years-months-days breakdown answers the question "how do I describe this to a human being?" Both are correct. The right format depends on what you are communicating.
- "547 days" is what a date calculator returns.
- "1 year, 6 months, and 1 day" is what an employment certificate, a visa application, or a child's age record typically uses.
Converting between the two is the subject of this guide.
How to calculate duration in years, months, and days
The manual method
Work through the span step by step:
- Count complete years first. From January 15, 2023 to June 21, 2026: the third anniversary falls on January 15, 2026, which is before June 21, 2026, so 3 complete years have passed.
- Count remaining complete months. From January 15, 2026 to June 21, 2026: 5 complete months (January 15 to June 15), with 6 days left over (June 15 to June 21).
- Count remaining days. 6 days.
- Result: 3 years, 5 months, and 6 days.
Spreadsheet method using DATEDIF
DATEDIF is the right tool for this. Put the start date in A1 and end date in B1:
- Complete years:
=DATEDIF(A1,B1,"Y")
- Remaining complete months:
=DATEDIF(A1,B1,"YM")
- Remaining days beyond last complete month:
=DATEDIF(A1,B1,"MD")
Combine them in one cell: =DATEDIF(A1,B1,"Y")&" years, "&DATEDIF(A1,B1,"YM")&" months, "&DATEDIF(A1,B1,"MD")&" days"
Worked examples
| Start date | End date | Duration | Total days |
|---|
| June 21, 1996 | June 21, 2026 | 30 years, 0 months, 0 days | 10,958 |
| January 15, 2023 | June 21, 2026 | 3 years, 5 months, 6 days | 1,253 |
| March 1, 2025 | June 21, 2026 | 1 year, 3 months, 20 days | 477 |
| November 10, 2020 | June 21, 2026 | 5 years, 7 months, 11 days | 2,049 |
| June 21, 2025 | June 21, 2026 | 1 year, 0 months, 0 days | 365 |
The month-end edge case
Month arithmetic gets awkward at month ends. Consider January 31 to February 28 in a non-leap year. Is that 1 complete month? Most systems say yes, because the end of February is the "equivalent" of January 31. DATEDIF follows this convention. But January 31 to March 1 is also treated as 1 month and 1 day by some systems, while others report it differently.
The practical takeaway: for dates that fall on the 29th, 30th, or 31st of a month, double-check the result if you are using month-based duration for anything legally or contractually significant. The total day count is unambiguous; the years-months-days breakdown can be interpreted in more than one way near month boundaries.
Common uses for years-months-days duration
- Employment records: "Total service: 7 years, 4 months, 12 days." Typically used in certificates of service, pension calculations, and visa supporting documents.
- Age statements: A child's pediatric age is often expressed in months (under 2 years) and then in years and months until school age. Adults quote whole years unless in a legal or medical context.
- Loan and mortgage terms: A 30-year mortgage's remaining term is often expressed as years and months. The exact day count matters for payoff calculations but the human-readable version uses the breakdown.
- Travel and visa history: Visa applications frequently ask for presence in a country as total days or as a years-months-days breakdown.
Converting total days to an approximate duration
When a precise DATEDIF breakdown is not available, you can estimate:
- 1 year = approximately 365.25 days (accounting for leap years on average).
- 1 month = approximately 30.44 days.
Divide your day total by 365.25 for approximate years, then take the decimal remainder and multiply by 12 for approximate months. This is an approximation: the exact breakdown requires knowing the actual start and end dates to handle month lengths correctly.
Related guides
For the raw day count that feeds into a duration calculation, see how to calculate days between two dates. For how leap years affect the total, see leap years and how they affect date math.
Frequently asked questions
How do I calculate a duration in years, months, and days?
Use the DATEDIF function in a spreadsheet with the "Y", "YM", and "MD" parameters to get complete years, remaining months, and remaining days. Or count manually: find complete years first, then complete months, then remaining days.
How do you calculate age in years and months?
Use =DATEDIF(birthdate,TODAY(),"Y") for complete years and =DATEDIF(birthdate,TODAY(),"YM") for additional complete months. Combined, these give the standard age expression.
Why does date duration in months give different results near month ends?
Because months vary in length and "one month" from January 31 has no precise equivalent in February. Most systems round to February 28 or 29, but edge cases can produce surprising results. Total day counts are always unambiguous.
How is a date duration different from just counting days?
Both represent the same span. Total days (547) is a single precise number. Years-months-days (1 year, 6 months, 1 day) is a human-readable breakdown better suited for documents, records, and conversation.
How do I calculate how long I have worked at a job?
Enter your hire date as the start date and today (or your last day) as the end date. Use DATEDIF to break the result into complete years and remaining months, or get the total days from the date calculator and convert manually.