Average of dates of birth

  • Thread starter Thread starter Greg
  • Start date Start date
G

Greg

I am trying to determine the average age of 155 people from their 155 dates
of birth. How do I do it?
tks,
jgn
 
If you have the dates in A1:A155 then this will give you the average age on
today's date

=TODAY()-AVERAGE(A1:A155)
 
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
 
Nice,I just learned something.
John
smartin said:
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
Click to expand...
 
Back
Top