Age from birthdate

[Nev]

Given the birthdate how can I compute the current age and display as yrs,
months, days? I'd like to see an AGE function added to the standard list of
builtin functions.

[Biff]

See this:

http://cpearson.com/excel/datedif.htm

Biff

"Nev" <[email protected]> wrote in message
news:[email protected]...
> Given the birthdate how can I compute the current age and display as yrs,
> months, days? I'd like to see an AGE function added to the standard list
> of
> builtin functions.

[Nev]

Thanks, I should have searched around more before posting the question. It's
curious why Microsoft haven't documented this function, seems like there's
been many enquiries on this topic. I think I'd still like to see an AGE
function or at least some detail in help about DATEDIF

"Biff" wrote:

> See this:
>
> http://cpearson.com/excel/datedif.htm
>
> Biff
>
> "Nev" <[email protected]> wrote in message
> news:[email protected]...
> > Given the birthdate how can I compute the current age and display as yrs,
> > months, days? I'd like to see an AGE function added to the standard list
> > of
> > builtin functions.
>
>
>

[Peo Sjoblom]

Most likely because it will give an incorrect answer during certain
conditions

http://tinyurl.com/j5hun





--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Nev" <[email protected]> wrote in message
news:[email protected]...
> Thanks, I should have searched around more before posting the question.
> It's
> curious why Microsoft haven't documented this function, seems like there's
> been many enquiries on this topic. I think I'd still like to see an AGE
> function or at least some detail in help about DATEDIF
>
> "Biff" wrote:
>
>> See this:
>>
>> http://cpearson.com/excel/datedif.htm
>>
>> Biff
>>
>> "Nev" <[email protected]> wrote in message
>> news:[email protected]...
>> > Given the birthdate how can I compute the current age and display as
>> > yrs,
>> > months, days? I'd like to see an AGE function added to the standard
>> > list
>> > of
>> > builtin functions.
>>
>>
>>

[paulrm906]

Hello Nev
I am no expert but the below formula is what I use to determin someones age in yrs,mths,days. M2 is their bithdate where as N2 is equal to now.
I hope this works for you as I do not have any problems at all.

=DATEDIF(M2;N2;"y") & " y; " & DATEDIF(M2;N2;"ym") & " m; " & DATEDIF(M2;N2;"md") & " d"

If the person is 25 the result will look something like this: 25y;5m;21d

Oh and sorry but you might have to change the ; to , depending on which version of "Office" you are using.

Paul Maynard
Moscow
Russia

[Nev]

Hmm, this is not good. I'd rather Microsoft disable a function than have it
return an incorrect result, however obscure. Does the VBA DATEDIFF also
return incorrect results?

What is the Microsoft solution for providing age as returned by this
function (most the time)?

"Peo Sjoblom" wrote:

> Most likely because it will give an incorrect answer during certain
> conditions
>
> http://tinyurl.com/j5hun
>
>
>
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> "It is a good thing to follow the first law of holes;
> if you are in one stop digging." Lord Healey
>
>
> "Nev" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks, I should have searched around more before posting the question.
> > It's
> > curious why Microsoft haven't documented this function, seems like there's
> > been many enquiries on this topic. I think I'd still like to see an AGE
> > function or at least some detail in help about DATEDIF
> >
> > "Biff" wrote:
> >
> >> See this:
> >>
> >> http://cpearson.com/excel/datedif.htm
> >>
> >> Biff
> >>
> >> "Nev" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Given the birthdate how can I compute the current age and display as
> >> > yrs,
> >> > months, days? I'd like to see an AGE function added to the standard
> >> > list
> >> > of
> >> > builtin functions.
> >>
> >>
> >>
>
>
>

[MartinW]

Hi Nev,

I don't know if I'm missing something here but, to me, all this seems to be
over-complicating something that is pretty simple.

A1: =TODAY()
A2: "your birthday"
A3: =A1-A2

Format A3 as yy:mm:dd

Works for me
Regards
Martin

[via135]

hi Nev!


assuming that your are using win2000
why don't you try

="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"

where C8 holds your date of birth

-via135

Hmm, this is not good. I'd rather Microsoft disable a function than have it
return an incorrect result, however obscure. Does the VBA DATEDIFF also
return incorrect results?

What is the Microsoft solution for providing age as returned by this
function (most the time)?

"Peo Sjoblom" wrote:

> Most likely because it will give an incorrect answer during certain
> conditions
>
> http://tinyurl.com/j5hun
>
>
>
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Excel 95 - Excel 2007
> Northwest Excel Solutions
> www.nwexcelsolutions.com
> "It is a good thing to follow the first law of holes;
> if you are in one stop digging." Lord Healey
>
>
> "Nev" <[email protected]> wrote in message
> news:[email protected]...
> > Thanks, I should have searched around more before posting the question.
> > It's
> > curious why Microsoft haven't documented this function, seems like there's
> > been many enquiries on this topic. I think I'd still like to see an AGE
> > function or at least some detail in help about DATEDIF
> >
> > "Biff" wrote:
> >
> >> See this:
> >>
> >> http://cpearson.com/excel/datedif.htm
> >>
> >> Biff
> >>
> >> "Nev" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > Given the birthdate how can I compute the current age and display as
> >> > yrs,
> >> > months, days? I'd like to see an AGE function added to the standard
> >> > list
> >> > of
> >> > builtin functions.
> >>
> >>
> >>
>
>
>