Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of dates of birth
I am trying to determine the average age of 155 people from their 155 dates
of birth. How do I do it? tks, jgn |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of dates of birth
If you have the dates in A1:A155 then this will give you the average age on
today's date =TODAY()-AVERAGE(A1:A155) "Greg" wrote: I am trying to determine the average age of 155 people from their 155 dates of birth. How do I do it? tks, jgn |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of dates of birth
Greg wrote:
I am trying to determine the average age of 155 people from their 155 dates of birth. How do I do it? tks, jgn Suppose the birthdates are in A1:A155. The average birthdate is simply =AVERAGE(A1:A155) The average age (in days) is =TODAY()-AVERAGE(A1:A155) A reasonable proxy for average age in years is =(TODAY()-AVERAGE(A1:A155))/365.25 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of dates of birth
Hi Greg
Say you have date of Birth : 1-Jan-60 in cell A1,: =DATEDIF(A1,TODAY(),"y") result 49 =DATEDIF(A1,TODAY(),"m") result 588 (months) and you could have it in days if you like. you need to use a column and drag down one of these formula, then use Average(range) HTH John "Greg" wrote in message ... I am trying to determine the average age of 155 people from their 155 dates of birth. How do I do it? tks, jgn |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of dates of birth
Nice,I just learned something.
John "smartin" wrote in message ... Greg wrote: I am trying to determine the average age of 155 people from their 155 dates of birth. How do I do it? tks, jgn Suppose the birthdates are in A1:A155. The average birthdate is simply =AVERAGE(A1:A155) The average age (in days) is =TODAY()-AVERAGE(A1:A155) A reasonable proxy for average age in years is =(TODAY()-AVERAGE(A1:A155))/365.25 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of dates of birth
Another option if you want the average age in whole years is
=DATEDIF(AVERAGE(A1:A155),TODAY(),"y") -- David Biddulph "John" wrote in message ... Nice,I just learned something. John "smartin" wrote in message ... Greg wrote: I am trying to determine the average age of 155 people from their 155 dates of birth. How do I do it? tks, jgn Suppose the birthdates are in A1:A155. The average birthdate is simply =AVERAGE(A1:A155) The average age (in days) is =TODAY()-AVERAGE(A1:A155) A reasonable proxy for average age in years is =(TODAY()-AVERAGE(A1:A155))/365.25 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort names and birth dates | Excel Discussion (Misc queries) | |||
Sort names and birth dates | Excel Discussion (Misc queries) | |||
Birth Dates | Excel Discussion (Misc queries) | |||
Average between two dates | Excel Discussion (Misc queries) | |||
How do I work out people's exact ages from their Dates of Birth? | Excel Discussion (Misc queries) |