Use `=DATEDIF(A1,TODAY(),”Y”)` to calculate age in years, where `A1` contains the birth date
Use `=YEARFRAC(A1,TODAY())` to calculate age as a decimal number
Use `=INT(YEARFRAC(A1,TODAY()))` to calculate age in completed years
Use `=DATEDIF(A1,TODAY(),”Y”)&” years”` to display age with text
Use `=DATEDIF(A1,TODAY(),”Y”)&” years, “&DATEDIF(A1,TODAY(),”YM”)&” months”` to display years and months
Use `=DATEDIF(A1,TODAY(),”Y”)&” years, “&DATEDIF(A1,TODAY(),”YM”)&” months, “&DATEDIF(A1,TODAY(),”MD”)&” days”` to display years, months, and days
Replace `A1` with the cell that contains the date of birth
Format the birth date cell as a date if Excel does not recognize it correctly