Hi,

I'll repost the answer

I've never understood the value of using months in calculating age, is
someone born on 1 feb the same age as someone born 1 jan at the end of those
months? I think not. However, try this

=DATEDIF(B1,A1,"y")&" years "&DATEDIF(B1,A1,"ym")&" months
"&DATEDIF(B1,A1,"md")&" days"

datedif isn't documented in excel so for help look here
http://www.cpearson.com/excel/datedif.aspx

Be aware that this formula can throw up odd results, try these dates

Some odd results arise with that formula when it is used for this kind of
determination:

DOB: 31 Jan 1943
DOD: 01 Mar 2008

Your Formula: 65 y 1 m -1 d


Mike





"Boyertown Casket" wrote:

Would you please direct me to the answer? I can't find it. Thank you.

Jerry

"Mike H" wrote:

Your earlier post came through and has been answered

Mike

"Boyertown Casket" wrote:

I am sorry if this is a repost - my earlier post did not seem to be processed.

I have DATE OF BIRTH in cell A1 and DATE OF DEATH in Cell B1. I would like
to place the elapsed time in Cell C1. The format for Cell C1 would be: 79
Years 6 Months 3 Days. How would I write the formula?

Any help you can give me to accomplish this would be appreciated.

Thank you.

Jerry