The following formulas show how to calculate current age from a date of birth.
Calculate age in years
This formula will calculate the current age in full years – for example “32”.
B2 is the field containing the date of birth.
=INT((TODAY()-B2)/365)
Calculate age in years, months and days
This formula will calculate the years, months and days – for example “32 Years, 1 Month, 2 Days”.
Where the value is 1 it will use the singular – year, month, day.
B2 is the field containing the date of birth.
=IF(DATEDIF(B2,TODAY(),"Y")=1,DATEDIF(B2,TODAY(),"Y")&" Year, ",DATEDIF(B2,TODAY(),"Y")&" Years, ")&IF( DATEDIF(B2,TODAY(),"YM")=1,DATEDIF(B2,TODAY(),"YM") & " Month, ",DATEDIF(B2,TODAY(),"YM")& " Months, ") &IF(DATEDIF(B2,TODAY(),"MD")=1,DATEDIF(B2,TODAY(),"MD")&" Day",DATEDIF(B2,TODAY(),"MD")&" Days")