Re: Calculating age of death

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

<way more so than simply specifying years and days,>

Indeed. Financial (and actuarial, my area of interest) systems often use this. But because product specifications often *do* refer
to months, the 360-day system is somewhat popular in those groups. Not that it's perfect!
It assumes a 360-day year, consisting of 12 30-day months.
As you can imagine, the remaining 5 or 6 days are subject to lots of different interpretations, but AFAIK they boil down to 2
systems; NASD or European (see HELP for DAYS360).

If only customers would specify what "number of months difference" means (to them).....

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Rick Rothstein (MVP - VB)" <rick.newsNO.SPAM@xxxxxxxxxxxxxxxxxx> wrote in message news:%23$j$4tKdIHA.4880@xxxxxxxxxxxxxxxxxxxxxxx
| >>Maybe
| >>
| >>=DATEDIF(A1,A2,"y")&" y "&DATEDIF(A1,A2,"ym")&" m "&DATEDIF(A1,A2,"md")&"
| >>d"
| >>
| >>Where a1= DOB
| >>a2 = DOD
| >
| > 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
|
| I've always thought measuring a time span using years, months and days is
| somewhat useless as the months part is not a very definitive increment. The
| number of days spanned by some number of months differs depending on the
| months being spanned. Hell, even years can be somewhat problematic give the
| occurrence of leap years within time spans; but, when used by itself as a
| "rough" indicator of time span, this if fine; however, the accuracy implied
| by specifying a time span in years, months and days has always bothered me
| (way more so than simply specifying years and days, even though I recognize
| the inaccuracy introduced by the leap years here).
|
| Rick
|


.

Relevant Pages

  • Re: Calculating age of death
    ... I've always thought measuring a time span using years, ... (way more so than simply specifying years and days, ... the inaccuracy introduced by the leap years here). ... Microsoft MVP - Excel ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Calculating age of death
    ... DOB: 31 Jan 1943 ... DOD: 01 Mar 2008 ... I've always thought measuring a time span using years, ... (way more so than simply specifying years and days, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Scheduling Jobs - Last day of the month - HOWTO?
    ... any obvious mechanism for specifying the *last day* of the month. ... Unfortunately, my environment is Cygwin, and the job to be launched ... current year is a leap year: ... The script is run on the 28th and 29th of each February (by the ...
    (comp.os.linux.misc)