calculate ages from birthdates

[kimbo]

Does anyone know how I can calculate ages from birthdates in the form 12/13/1979?

Thanks.

[Paul B]

if your date in in B4 you could use
=DATEDIF(B4,NOW(),"y") & " years, " & DATEDIF(B4,NOW(),"ym") & " months, " & DATEDIF(B4,NOW(),"md") & " days"

[Dave Patton]

you can use Datedif
Datedif is in nearly all versions of Excel but it was only documented in Excel2000.

With Date of Birth as a valid date and cell named DOB see below or just use cell reference instead of DOB.

If you want all the information in one cell with text, consider

=DATEDIF(DOB,TODAY(),"Y")&" years, "&DATEDIF(DOB,TODAY(),"ym")& " months, and "&DATEDIF(DOB,TODAY(),"md") &" days"

You can extract the sub parts and have each part in a separate cell.

Note: There are some anomalies with the day calculations.

[ This Message was edited by: Dave Patton on 2002-04-19 11:34 ]

[Aladin Akyurek]

On 2002-04-19 10:59, Paul B wrote:
if your date in in B4 you could use
=DATEDIF(B4,NOW(),"y") & " years, " & DATEDIF(B4,NOW(),"ym") & " months, " & DATEDIF(B4,NOW(),"md") & " days"

Also:

=YEARFRAC(B4,TODAY(),1)

Requires Analysis Toolpak (an Add-In accessible via Tools|Add-Ins).