How to Calculate Duration Between Two Dates in Excel with the DATEDIF Function
Calculate duration between dates in Excel with the DATEDIF function. This works for days, months, or years.
Calculate duration between dates in Excel with the DATEDIF function. This works for days, months, or years.
Two formulas calculate age from date of birth in Google Sheets: DATEDIF and YEARFRAC. This guide covers both, with copy-paste examples for years only, years and months, and a full years/months/days breakdown.