Google Sheets How-to
Calculate Age from Date of Birth in Google Sheets (Years, Months, Days)
Calculate age from a date of birth in Google Sheets with DATEDIF: whole years, years-months-days, age on a set date, next birthday, plus leap-day and month-end edge cases.