calculate age in google sheets

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.