Birthday date formula?

  • Thread starter Thread starter Marty
  • Start date Start date
M

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.
 
in cell b4 enter:

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

HTH

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
in cell b4 enter:

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

HTH

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

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 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
 
Back
Top