Age from birthdate

[Guest]

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

 

[Guest]

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

 

[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

 

[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"

Paul Maynard
Moscow
Russia

 

[Guest]

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)?

 

[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

 

[Guest]

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...

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk