Re: what formula do i need to calculate a persons age
- From: JC <jc@xxxxxxxxxxxxxxx>
- Date: Wed, 20 Sep 2006 19:28:41 +1000
On Wed, 20 Sep 2006 07:34:09 +1000, JC <jc@xxxxxxxxxxxxxxx> wrote:
On Tue, 19 Sep 2006 02:49:02 -0700, brenner <brenner@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
using todays date what formula do i use to calculate a person age using their
date of birth
The complete formula is
=DATEDIF(A1,TODAY(),"Y")&" years "&DATEDIF(A1,TODAY(),"YM")&" months
"&DATEDIF(A1,TODAY(),"MD")&" days"
You can trim the formula to suit your needs to give only x years or x years y
months or have the full formula give you x tears y months z days.
There is a minor error in leap years for people born on 28th February - the
formula assumes that the DOB is 1st March.
Correction - the minor error arises if the person is born on 29th February i.e.
born in a leap year. The formula is correct for leap years but assumes that
the DOB is 1st March in non leap years.
There was some argument when this was last discussed if this really was an
error. The purists argued that people born on 29th February only have a
birthday every 4 years whereas the counter argument said that they have
birthdays on 29th February in leap years and 1st March in non leap years.
Since I wasn't born, or know anyone who was born, on 29th February I have no
direct knowledge how people in this predicament handle their birthdays. However,
I would subscribe to the birthday each year rather than one every 4 years,
particularly for a child.
--
Cheers . . . JC
.
- References:
- Prev by Date: RE: Filter
- Next by Date: Re: Help with lookup
- Previous by thread: Re: what formula do i need to calculate a persons age
- Next by thread: Re: What means Fix in the status bar in excel
- Index(es):
Relevant Pages
|
