Donate SIGN UP

Excel charts

Avatar Image
Gary W | 19:32 Sat 12th Feb 2005 | Technology
5 Answers
using Excel if i had dates of birth in one column eg 26/12/1959 what equasion / sum would i need to put in the next column to give me the age eg 45yrs (it would need to update itself automatically. Also a sum to convert a person weight in kilograms eg; 64 kg to 10St 1lb must be STONES & POUNDS not decimalised.
Gravatar

Answers

1 to 5 of 5rss feed

Best Answer

No best answer has yet been selected by Gary W. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Age
=INT((TODAY()-A1)/365.25)

where A1 is the cell with the presons birth date.
Weight Stones and Pounds


=CONCATENATE(ROUND((A4*2.20462262)/14,0)," St ",ROUND(MOD((A4*2.20462262),14),0)," lbs")


A slightly more elegant (?) fix for the Weight formula which corrects the 14lb anomaly

=CONCATENATE(INT((A4*2.20462262+0.5)/14)," St  ",INT(MOD((A4*2.20462262+0.5),14))," lb")

(watchout for a non-breaking space tag in the formula)

Ignore the n-b space comment!

...  and this one for more detailed age analysis

=DATEDIF(A1,NOW(),"y") & " yrs  " & DATEDIF(A1,NOW(),"ym") & " mths  " & DATEDIF(A1,NOW(),"md") & " days"

1 to 5 of 5rss feed

Do you know the answer?

Excel charts

Answer Question >>