How to calculate age from today's date?

Mom Types · External Since: Feb 21, 2007 Posts: 3

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

Mike · External Since: Mar 10, 2006 Posts: 1351

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")

"Mom Types" wrote:

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

Mike · External Since: Mar 10, 2006 Posts: 1351

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 Types · External Since: Feb 21, 2007 Posts: 3

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.

Mom Types · External Since: Feb 21, 2007 Posts: 3

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

JE McGimpsey · External Since: Feb 05, 2004 Posts: 3284

One way:

=DATEDIF(A1,O1,"y")

for birthdate in A1.

In article <B9AF1B03-3D29-4B2D-819C-C8457EAFD96A RemoveThis @microsoft.com>,
Mom Types <MomTypes RemoveThis @discussions.microsoft.com> wrote:

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

Paul B · External Since: Nov 03, 2004 Posts: 1078

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" <MomTypes.TakeThisOut@discussions.microsoft.com> wrote in message
news:B9AF1B03-3D29-4B2D-819C-C8457EAFD96A@microsoft.com...
> Using =TODAY() in O1 cell, how do I calculate ages based on birthdates?
> Thank
> you.