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

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

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

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

It is one of those things left over from yesteryear. Tradition, I suppose.

Thanks for your answer. I will try it and thanks for making me aware of
some of the odd results I may obtain.

"Mike H" wrote:

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

I could not get it to work. I appreciate your support though.

Jerry

"Mike H" wrote:

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