value of 2 cells
 

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

value of 2 cells
 

On Apr 8, 3:52*pm, tisaman wrote:
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 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

value of 2 cells
 

thank you
i guess i did post to the wrong forum
i have reposted in the correct spot
thanks brian

"Brian B." wrote:

On Apr 8, 3:52 pm, tisaman wrote:
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 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

value of 2 cells
 

"tisaman" wrote in message
...
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 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


--
roger