How to get your age in excel?

You can use the =DATEDIF to calculate a person's age. For example, the formula below will calculate the age of a person as of the current date, where DOB is the person's date of birth.

Formula: =DATEDIF(Date1, Date2, Interval)

="Hi " & "Your name" & " your age is " & DATEDIF(YourDOB,TODAY(),"Y") & " Year " & DATEDIF(YourDOB,TODAY(),"ym") & " Months and " & DATEDIF(YourDOB,TODAY(),"md") & " Day's"

Note : Make sure that you wright “your name” and  “your DOB” correct or pass cell reference in place of DOB.

For example:-

="Hi " & B4 &    " your age is " & DATEDIF(C4,TODAY(),"Y") & " Year " & DATEDIF(C4,TODAY(),"ym") & " Months and " & DATEDIF(C4,TODAY(),"md") & " Day's"

Hi Excel A your age is 23 Year 1 Months and 21 Day's



Others Criteria's

=DATEDIF(Date1, Date2, Interval)

Where:
Date1 is the first date,
Date2 is the second date,
Interval is the interval type to return.

If Date1 is later than Date2, DATEDIF will return a #NUM! error. If either Date1 or Date2 is not a valid date, DATEDIF will return a #VALUE error.
The Interval value should be one of below list.

If Interval is not one of the items listed in above, DATEDIF will return a #NUM error. 


If you are including the Interval string directly within the formula, you must enclose it in double quotes:

=DATEDIF(Date1,Date2,"m")

If you have the interval in another cell referenced by the formula, that cell should not have quotes around the interval string. For example, with the formula

=DATEDIF(Date1,Date2,A1)

cell A1 should contain m not "m".

EXCEL is Fun..!!!