Calculating age of death
On Thu, 21 Feb 2008 06:30:02 -0800, Mike H
wrote:
Maybe
=DATEDIF(A1,A2,"y")&" y "&DATEDIF(A1,A2,"ym")&" m "&DATEDIF(A1,A2,"md")&" d"
Where a1= DOB
a2 = DOD
Mike H
Since this is in a hospital, and the result probably going on some kind of
legal document, I think you need to have the legal definition of "age" for this
purpose.
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
--ron
|