Birthdate to Age

[Lizzy]

Hi everyone. I need help with excel. I want to be able to type in a
birthdate, and be able to see the age of the person. Is there a
formula that can change a birthdate into an age? For example, I want
to type 1984/09/16 into a cell and the cell in return show the number
24. Is there a way this is possible? Please help! Thank you!

Or....does excel have auto correct? where a birthday typed in can
automatically change to the age? If anyone can help me just let me
know. Thanks again!

[Karthik Bhat]

Hi

Say A1 has the date 16/9/1984 (rememeber: it must be in date format)
In A2 enter =Today() this will give you the current date (15/2/2009)
Now enter the following formula in A3 =ROUNDDOWN((A2-A1)/365.25,0)
You now have the age. Remember you can replace rounddown with 'round'
or with 'roundup' function in the above formula depending on changes
(if any) in your requirement.

Thx
KB

[Sixthsense]

Assume that your data (i.e.) Date is in A1 Cell, just paste this
formula in A2 cell

For getting Age by Years
=DATEDIF(A1,TODAY(),"Y")

For getting Age with Years-Month-Days
=DATEDIF(A1,TODAY(),"Y")&" Years "&DATEDIF(A1,TODAY(),"YM")&" Months
"&DATEDIF(A1,TODAY(),"MD")&" Days"

Regards,

Sixthsense