Calculating age from date of birth

chris · Sep 17, 2003

Given a date of birth in dd-mm-yy form, how can the age in
completed years be calculated using a function, or
combination of functions?

Don Guillett · Sep 17, 2003

Have you tried the archives for this very often asked question.

Chip Pearson · Sep 17, 2003

Chris,

Use =DATEDIF(A1, TODAY(),"y")

where A1 is the date of birth. See www.cpearson.com/excel/datedif.htm for
more info about the DATEDIF function.

Guest · Oct 24, 2003

I am looking for the same formula. Did you find the answer?

Calculating age from date of birth and ignoring if blank	5	Nov 24, 2010
create calculated field for age in pivot tables	4	Mar 3, 2010
Calculating present age if date of birth is given.	3	Jul 25, 2008
Completed years and monhts	6	May 23, 2008
Excel - Calculate age from DOB in years, months days	7	Feb 10, 2010
Count/Calculation According to Age of the Person	1	Jan 10, 2008
"how do I calculate age by using date of birth details"	5	Feb 14, 2009
calculate date of birth with an end date and age	1	Jan 7, 2010

Calculating age from date of birth

chris

Don Guillett

Chip Pearson

Guest

Ask a Question

Similar Threads