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.

See this:

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

Biff

"Nev" wrote in message
...
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.

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" wrote in message
...
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.

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" wrote in message
...
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" wrote in message
...
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.

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"

Paul Maynard
Moscow
Russia


--
paulrm906
------------------------------------------------------------------------
paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776
View this thread: http://www.excelforum.com/showthread...hreadid=550739

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" wrote in message
...
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" wrote in message
...
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.

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

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

Nev Wrote:
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" wrote in message
...
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" wrote in message
...
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.








--
via135
------------------------------------------------------------------------
via135's Profile: http://www.excelforum.com/member.php...o&userid=26725
View this thread: http://www.excelforum.com/showthread...hreadid=550739

I agree with Martin.

=NOW()-DATE(YEAR(A1),MONTH(A1),DAY(A1))

Assuming the birth date is in A1 and using Martin's cell format or your own
custom one for destination cell.

Hope it helps...


"Nev" wrote:

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.

This seems to be an old thread from last June, so just for the archives
really:

I agree with Martin.

I'm afraid that I don't agree with both you and Martin. If I was born on
this day in the same year as I actually was, then using the formula that
Martin suggested (A1-A2) or yours and formatting as Martin says ("yy mm dd")
I get 64 12 30 (64 years,12 months & 30 days).

A correct solution has already been posted.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"OC" wrote in message
...
I agree with Martin.

=NOW()-DATE(YEAR(A1),MONTH(A1),DAY(A1))

Assuming the birth date is in A1 and using Martin's cell format or your
own
custom one for destination cell.

Hope it helps...


"Nev" wrote:

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.