In excel, the age can be computer by subtracting the birth date of a person
from todays date. Note that
NOW() function returns current date and time
AVERAGE() function yields the average
So you should follow following steps to obtain the result:-
1.In any column A enter name and in B, enter the date of birth (suppose you
have entered records from B1 to B20)
2.Select any other cell (say C1)
3.Enter following formula
=NOW()-AVERAGE(B1:B20)
Now you are done !
Have a nice time€¦€¦€¦
Chris
------
Convert your Excel spreadsheet into an online calculator.
http://www.spreadsheetconverter.com
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200901/1