Thanks:  0
Likes:  0

# Thread: calculate ages from birthdates

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

Thanks.

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

3. 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 ]

4. 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)

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•