G
Guest
Using =TODAY() in O1 cell, how do I calculate ages based on birthdates? Thank
you.
you.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
One way:
=DATEDIF(A1,O1,"y")
for birthdate in A1.
=DATEDIF(A1,O1,"y")
for birthdate in A1.
G
Guest
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")
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")
G
Guest
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"
=DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months,
" & DATEDIF(A1,TODAY(),"MD") & " Days"
P
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
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
G
Guest
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.
formula worked the best in a Fill. Thanks for your help.
G
Guest
Thank you to all for your help. All the formulas worked very well!