Excel 2016 – How to calculate age from date of birth

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")

 

 

Was this article helpful?

Related Articles