Birthday date formula?

[Marty]

About a year ago I found a formula to calculate the number of years, months and days a person had lived just by typing in their birthdate. ie. 13 Jan 1927 cal: 77years, 11months, 3days. Does anyone know what it may be? Thanks.

[JMay]

in cell b4 enter:

=DATEDIF(A4,NOW(),"y") & " years, " & DATEDIF(A4,NOW(),"ym") & " months, " &DATEDIF(A4,NOW(),"md") & " days old"

HTH

"Marty" <[email protected]> wrote in message news:%[email protected]...
About a year ago I found a formula to calculate the number of years, months and days a person had lived just by typing in their birthdate. ie. 13 Jan 1927 cal: 77years, 11months, 3days. Does anyone know what it may be? Thanks.

[JMay]

What the "heck" is causing this "stacking" of a pasted formula?
Computers, always agrevating you somehow,,, go figure..
This hase been happening since I moved from Win 98 to Win XP (Home).
hummmmm
"JMay" <[email protected]> wrote in message news:eq4kf.10502$_k3.492@dukeread01...
in cell b4 enter:

=DATEDIF(A4,NOW(),"y") & " years, " & DATEDIF(A4,NOW(),"ym") & " months, " &DATEDIF(A4,NOW(),"md") & " days old"

HTH

"Marty" <[email protected]> wrote in message news:%[email protected]...
About a year ago I found a formula to calculate the number of years, months and days a person had lived just by typing in their birthdate. ie. 13 Jan 1927 cal: 77years, 11months, 3days. Does anyone know what it may be? Thanks.

[Gary''s Student]

See:


http://www.cpearson.com/excel/datedif.htm
--
Gary''s Student


"Marty" wrote:

> About a year ago I found a formula to calculate the number of years, months and days a person had lived just by typing in their birthdate. ie. 13 Jan 1927 cal: 77years, 11months, 3days. Does anyone know what it may be? Thanks

[Bernard Liengme]

visit www.cpearson.com


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Marty" <[email protected]> wrote in message news:%[email protected]...
About a year ago I found a formula to calculate the number of years, months and days a person had lived just by typing in their birthdate. ie. 13 Jan 1927 cal: 77years, 11months, 3days. Does anyone know what it may be? Thanks.

[Marty]

Thanks to all.

[Dave Peterson]

Could it be that you're not posting in plain text?


--

Dave Peterson

[JMay]

Thanks Dave;
Checked my Ooutlook Express settings Tools,Options
Send tab, and Newsgroups is set to "Plain text"
Message format -- UUencode checked, versus
MIMe -- whatever that means...??
Tks,
Jim


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> Could it be that you're not posting in plain text?
>
>
> --
>
> Dave Peterson