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
|