DETERMINING NUMBER OF DAYS / MONTHS / YEARS BETWEEN TWO DATES

B

Boyertown Casket

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
 
M

Mike H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ELAPSED TIME BETWEEN TWO DATES 5
Formula to calculate exact months and days between two dates 3
Months between two dates 5
count the days between 2 dates and convert 4
Add years, months, days to a date 5
Calculating age at different points in time 1
Converting dates to years, months & days 1
Calc Number of Months PER YEAR Between Dates 2

Top