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.

in cell b4 enter:

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

HTH

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

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

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


--

Dave Peterson

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" wrote in message
...
Could it be that you're not posting in plain text?


--

Dave Peterson

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

visit www.cpearson.com


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

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

Thanks to all.