Excel charts

[Gary W]

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.

[WoWo]

Age
=INT((TODAY()-A1)/365.25)

where A1 is the cell with the presons birth date.

[WoWo]

Weight Stones and Pounds


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

[kempie]

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)

[kempie]

Ignore the n-b space comment!

[kempie]

...  and this one for more detailed age analysis

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