Calculating age from date of birth

[chris]

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]

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

 

[Chip Pearson]

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.

 

[Michael D.]

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