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

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?

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

sjric2 -

Chip Pearson's information may help:

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

- Mike


"sjric2" wrote in message
...
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?

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

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


"sjric2" wrote:

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?

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

Thanks Mike, that was exactly what I needed :)

"Mike Middleton" wrote:

sjric2 -

Chip Pearson's information may help:

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

- Mike


"sjric2" wrote in message
...
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?