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

One way:

=DATEDIF(A1,O1,"y")

for birthdate in A1.

In article ,
Mom Types wrote:

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

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(TO DAY())=MONTH(A13),DAY(TODAY())=DAY(A13))),(TODAY( )-A13)/365.25,(TODAY()-A13)/365.25),"0")



"Mom Types" wrote:

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

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"

"Mom Types" wrote:

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

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" wrote in message
...
Using =TODAY() in O1 cell, how do I calculate ages based on birthdates?
Thank
you.

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.

"Mike" wrote:

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"

"Mom Types" wrote:

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

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