View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Chris Bode via OfficeKB.com Chris Bode via OfficeKB.com is offline
external usenet poster
 
Posts: 47
Default Average of dates of birth

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