value of 2 cells

  • Thread starter Thread starter tisaman
  • Start date Start date
T

tisaman

i have three cells:
one with the date of birth the other with the date of death
and in the 3rd cell i would like to get the age between the two other cells
which is
"the age at time of death".
What formula would i use in the 3rd cell to get the age at time of death?
thank you so much for your help.
tonia
 
i have three cells:
one with the date of birth the other with the date of death
and in the 3rd cell i would like to get the age between the two other cells
which is
"the age at time of death".
What formula would i use in the 3rd cell to get the age at time of death?
thank you so much for your help.
tonia
Click to expand...


I don't think that you posted your question in the proper forum
but ....

The quick and dirty way, is this simple formula:

=(Death Date - Birth Date)/365.25

*Note: 365.25 is the assumed number of days in a year taking into
consideration leap year.

-Brian
 
thank you
i guess i did post to the wrong forum
i have reposted in the correct spot
thanks brian
 
tisaman said:
i have three cells:
one with the date of birth the other with the date of death
and in the 3rd cell i would like to get the age between the two other cells
which is
"the age at time of death".
What formula would i use in the 3rd cell to get the age at time of death?
thank you so much for your help.
tonia
Click to expand...

I think it's...


=IF(OR(MONTH(B1)<MONTH(A1),AND(MONTH(B1)=MONTH(A1),DAY(B1)<DAY(A1))),YEAR(B1
)-YEAR(A1)-1,YEAR(B1)-YEAR(A1))

where A1 = dob
and B1 = dod

i.e. age = year of death - year of birth
unless

1. the month of death was less then the month of birth OR
2. the months were the same AND the day of death was less than the day of
birth

in which case you subtract 1 from the age
 
Back
Top