age of a person

[tony.reynolds]

What id like to do is to display the age of a person like 23Years 6Months in column D,

Date of births are in column C

Simple no doubt but im stuck..

 

[T. Valko]

What id like to do is to display the age of a person like 23Years 6Months in column D,

Date of births are in column C

Simple no doubt but im stuck..

See this:

http://www.cpearson.com/Excel/datedif.aspx

It's down near the bottom of the page.

 

[Peter_SSs]

Try this

Excel Workbook
	C	D
1	DoB	3/01/12
2	18/09/82	29 Years 3 Months
3	23/07/01	10 Years 5 Months
Age

 

[anandvarma]

try this

=DATEDIF(C1,TODAY(),"y")&" Years "&DATEDIF(C1,TODAY(),"ym")&" Months"

 

[tony.reynolds]

try this

=DATEDIF(C1,TODAY(),"y")&" Years "&DATEDIF(C1,TODAY(),"ym")&" Months"

Thanks perfect!

 

[anandvarma]

i am glad it helped you

thanks for feed back

 

[Peter_SSs]

Just note that TODAY() is a volatile function. That's why I suggested putting that function just once in a single cell and referring all the formulas to that cell.

 

[anandvarma]

Dear Peter_SSs,

Thanks for the suggestion. Further i have observed that many of the users are not looking at the all the answers. they are just going to the last one and trying the same. if it works out they are acknowledging that only.

anand varma