How to calculate age in Excel.
by THavamani[ Edit ] 2014-04-10 19:13:14
We can calculate age in Excel by using following formula.
If B1 is the Date of Birth (DOB),
This Excel Formula gives the age in years.
=DATEDIF(B1,TODAY(),"y")
This Excel formula gives the age in months
=DATEDIF(B1,TODAY(),"M")
This Excel formula gives the age in days
=DATEDIF(B1,TODAY(),"D")
This Excel formula gives the age in years, months and days
=DATEDIF(A1,TODAY(),"y")&" Years "&DATEDIF(A1,TODAY(),"ym")&" Months "&DATEDIF(A1,TODAY(),"md")&" Days"
These formulas are used to calculate age in Excel..
