Calculate Age...?

I have a sheet with the formula..

=DATEDIF(A20,NOW(),"Y")&":Yrs "&DATEDIF(A20,NOW(),"YM")&":Months
"&DATEDIF(A20,NOW(),"MD")&":Days"

where A20 contains a birthday...!

Can any of you clever guys tell me why It doesn't seem to be working
correctly.
Its supposed to return the age "X:Yrs Y:Months Z:Days".


Thanx for any assist.
Andrew

Andrew,

The formula works fine for me. Exactly what problems are you
having?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Andrew" <NoToSPAM@home> wrote in message
news:eMTf8bd0FHA.1924@TK2MSFTNGP14.phx.gbl...
>I have a sheet with the formula..
>
> =DATEDIF(A20,NOW(),"Y")&":Yrs
> "&DATEDIF(A20,NOW(),"YM")&":Months
> "&DATEDIF(A20,NOW(),"MD")&":Days"
>
> where A20 contains a birthday...!
>
> Can any of you clever guys tell me why It doesn't seem to be
> working
> correctly.
> Its supposed to return the age "X:Yrs Y:Months Z:Days".
>
>
> Thanx for any assist.
> Andrew
>
>

Works fine for me. What do you get?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Andrew" <NoToSPAM@home> wrote in message
news:eMTf8bd0FHA.1924@TK2MSFTNGP14.phx.gbl...
> I have a sheet with the formula..
>
> =DATEDIF(A20,NOW(),"Y")&":Yrs "&DATEDIF(A20,NOW(),"YM")&":Months
> "&DATEDIF(A20,NOW(),"MD")&":Days"
>
> where A20 contains a birthday...!
>
> Can any of you clever guys tell me why It doesn't seem to be working
> correctly.
> Its supposed to return the age "X:Yrs Y:Months Z:Days".
>
>
> Thanx for any assist.
> Andrew
>
>

Works for me if a valid date like 9/14/1978 is entered in A20.

Returns 27:Yrs 1:Months 1:Days

What does "not working" mean to you?


Gord Dibben Excel MVP


On Sat, 15 Oct 2005 23:22:50 +0100, "Andrew" <NoToSPAM@home> wrote:

>I have a sheet with the formula..
>
>=DATEDIF(A20,NOW(),"Y")&":Yrs "&DATEDIF(A20,NOW(),"YM")&":Months
>"&DATEDIF(A20,NOW(),"MD")&":Days"
>
>where A20 contains a birthday...!
>
>Can any of you clever guys tell me why It doesn't seem to be working
>correctly.
>Its supposed to return the age "X:Yrs Y:Months Z:Days".
>
>
>Thanx for any assist.
>Andrew
>

Tried : Wed-05/Jan/1944, But "Mother" is 62'n a Bit.
(Presume she's not telling fibs)

I get---- 61:Yrs 9:Months 11:Days

Jan is (Nov/Dec) 2 Months + xDays away, and ans Just dont look right.
Wondering if Leap years etc. are taken into account with "DateDif"..?
-----------
Thanx Guys
Andrew



"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:aq03l1tj6ak9smsdhqaf606n2mvt59v1gl@4ax.com...
| Works for me if a valid date like 9/14/1978 is entered in A20.
|
| Returns 27:Yrs 1:Months 1:Days
|
| What does "not working" mean to you?
|
|
| Gord Dibben Excel MVP
|
|
| On Sat, 15 Oct 2005 23:22:50 +0100, "Andrew" <NoToSPAM@home> wrote:
|
| >I have a sheet with the formula..
| >
| >=DATEDIF(A20,NOW(),"Y")&":Yrs "&DATEDIF(A20,NOW(),"YM")&":Months
| >"&DATEDIF(A20,NOW(),"MD")&":Days"
| >
| >where A20 contains a birthday...!
| >
| >Can any of you clever guys tell me why It doesn't seem to be working
| >correctly.
| >Its supposed to return the age "X:Yrs Y:Months Z:Days".
| >
| >
| >Thanx for any assist.
| >Andrew
| >
|

On Sun, 16 Oct 2005 00:12:30 +0100, "Andrew" <NoToSPAM@home> wrote:

>Tried : Wed-05/Jan/1944, But "Mother" is 62'n a Bit.
>(Presume she's not telling fibs)
>
>I get---- 61:Yrs 9:Months 11:Days
>
>Jan is (Nov/Dec) 2 Months + xDays away, and ans Just dont look right.
>Wondering if Leap years etc. are taken into account with "DateDif"..?
>-----------

Although your mother may be well into her 62nd year on this planet, she won't
be celebrating her 62nd birthday until she finishes up that year.

If she was born Jan 1944, she won't finish up her 62nd year until Jan 2006.


--ron

Thanx Guys, Thought the thory behind the formula was good...!
Just my common sense thats a bit dodgy..!

Thanx Again
Andrew

-----
"Ron Rosenfeld" wrote:

> On Sun, 16 Oct 2005 00:12:30 +0100, "Andrew" <NoToSPAM@home> wrote:
>
> >Tried : Wed-05/Jan/1944, But "Mother" is 62'n a Bit.
> >(Presume she's not telling fibs)
> >
> >I get---- 61:Yrs 9:Months 11:Days
> >
> >Jan is (Nov/Dec) 2 Months + xDays away, and ans Just dont look right.
> >Wondering if Leap years etc. are taken into account with "DateDif"..?
> >-----------
>
> Although your mother may be well into her 62nd year on this planet, she won't
> be celebrating her 62nd birthday until she finishes up that year.
>
> If she was born Jan 1944, she won't finish up her 62nd year until Jan 2006.
>
>
> --ron
>