Showing Years and Months
Key points
- Build the formula
- See the second one
- Copy it
DATEDIF Builder also shows a formula that joins years and months as text.
Steps
- Build the formula
- See the second one
- Copy it
The result is text.
Use "Build a DATEDIF Formula" (free)
Tools that go well with this
- Excel Serial Number and Date Converter: Convert Excel serial numbers and dates.
- Calculate Age, Days Between Dates and Date Offsets: Calculate age and days between dates.
- Build an IF Formula: Build an IF formula.