How to calculate age in Excel.

by THavamani 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..
757
like
0
dislike
0
mail
flag

You must LOGIN to add comments