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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averaging a list of dates / ages 1
Using Year of Birth, from DOB, in later calculations 5
How do I calculate a persons age from birth dates 1
Calculating When Somebody Reaches a Certain Age 4
Convert date to Age 3
How to move data from rows to columns 6
Calculate age 3
How do I calculate a person's age from date of birth and a date 2

Back
Top