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

chris

Don Guillett

Chip Pearson

Guest