How to calculate age from today's date?
 

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

How to calculate age from today's date?
 

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.

How to calculate age from today's date?
 

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.

How to calculate age from today's date?
 

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.

How to calculate age from today's date?
 

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.

How to calculate age from today's date?
 

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.

How to calculate age from today's date?
 

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