DETERMINING NUMBER OF DAYS / MONTHS / YEARS BETWEEN TWO DATES
 

I have the Date of Death in Cell A1 and the Date of Birth in Cell B1. I
would like to place the number of days / months / years this person was alive
in Cell C1. I would like the output to reflect this: 79 Years 6 Months 3
Days

Thank you for your help and support.

Jerry

DETERMINING NUMBER OF DAYS / MONTHS / YEARS BETWEEN TWO DATES
 

Hi,

I've never understood the values of using monthe in calculating age, is
someome 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

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

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



"Boyertown Casket" wrote:

I have the Date of Death in Cell A1 and the Date of Birth in Cell B1. I
would like to place the number of days / months / years this person was alive
in Cell C1. I would like the output to reflect this: 79 Years 6 Months 3
Days

Thank you for your help and support.

Jerry