Calculating age of death
Maybe
=DATEDIF(A1,A2,"y")&" y "&DATEDIF(A1,A2,"ym")&" m "&DATEDIF(A1,A2,"md")&" d"
Where a1= DOB
a2 = DOD
Mike H
"Annie" wrote:
Hi
I work in a hospital and have to calculate what exact age someone is when
they die. I have birth date and date of death. How can I calculate in total
the age on death. Example, 45 years, 4 months and 5 days
Many thanks
--
Kind regards
Ann Shaw
|