How do I work out people's exact ages from their Dates of Birth?

K

krakowba

I want to develop a quick list of friends and family's ages. How do I get
Excel to work out someone's age from their date of birth.

I've tried using the Year function but that seems to round up to the nearest
full year - so someone who is say 21 will be shown as 22 as it merely
subtracts in whole years.
 
R

RagDyeR

Use the Datedif function, which is undocumented, except in XL2K.

Find instructions at Chip Pearson's site:

http://www.cpearson.com/excel/datedif.htm
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I want to develop a quick list of friends and family's ages. How do I get
Excel to work out someone's age from their date of birth.

I've tried using the Year function but that seems to round up to the nearest
full year - so someone who is say 21 will be shown as 22 as it merely
subtracts in whole years.
 
S

Sloth

=INT((A2-A1)/365)
and
=DATEDIF(A1,A2,"Y")
will both return the number of years between two dates. A1 is the
birthdate, and A2 is TODAY(). You might need to reformat the cell as general
after you put in the formula (it might try and output as a date otherwise).

You can also use the DATEDIF to get something like
22 years and 5 months
with this formula
=DATEDIF(A1,A2,"Y")&" years, and "&DATEDIF(A1,A2,"YM")&" months."
 
V

via135

hi

another try!

let us assume the date of birth is in A1

enter the formula in A2

=DATEDIF(A1,TODAY(),"Y")&"YEARS,"&DATEDIF(A1,TODAY(),"YM")&"MONTHS,"&DATEDIF(A1,TODAY(),"MD")&"DAYS."

is it ok?

-via135
 
K

krakowba

Thank you - and also thanks to everyone else who responded to my post. I've
tried out the advice and it works fine.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date of birth age formula 8
how do I work out age in years, months, days in excel 1
How do I calculate a person's age from date of birth and a date 4
From Date of Birth Select records inbetween ages 3
How do you calculate age from just having a Date of Birth? 2
working out ages from date of birth 1
HOW DO YOU CALCULATE AGE BY DATE OF BIRTH I NEED YEARS AND MONTHS 2
How do I calculate the age of a person from their ID no.? 2

Top