How to calculate age from today's date?

[Mom Types]

Using =TODAY() in O1 cell, how do I calculate ages based on birthdates? Thank
you.

 

[JE McGimpsey]

One way:

=DATEDIF(A1,O1,"y")

for birthdate in A1.

 

[Mike]

in any cell gives age so in this formula change a13 to your own cell
reference to your cell reference and you done.

=TEXT(IF(OR(MONTH(TODAY())>MONTH(A13),AND(MONTH(TODAY())=MONTH(A13),DAY(TODAY())>=DAY(A13))),(TODAY()-A13)/365.25,(TODAY()-A13)/365.25),"0")

 

[Mike]

Sorry here's a nicer one. Once again change A1 to your own cell reference

=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months,
" & DATEDIF(A1,TODAY(),"MD") & " Days"

 

[Paul B]

Mom, use datedif, have a look here for details

http://www.cpearson.com/excel/datedif.htm#Age
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Mom Types]

This one works the best for me; I have a list of clients/birthdates and this
formula worked the best in a Fill. Thanks for your help.

 

[Mom Types]

Thank you to all for your help. All the formulas worked very well!