formula to calculate age at a given date in years and months?

sjric2 · Feb 18, 2007

Hi,

Does anyone have a formula to calculate a person's age in years and months
eg 20years, 10 months based on a specified point in time?

Mike Middleton · Feb 18, 2007

sjric2 -

Chip Pearson's information may help:

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

- Mike

Teethless mama · Feb 18, 2007

=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months"

sjric2 · Feb 18, 2007

Thanks Mike, that was exactly what I needed

Mike Middleton said:
sjric2 -

Chip Pearson's information may help:

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

- Mike