Average Age

B

Brian

I'm using Excel 2000.... I have a row of dates of birth. I would like a
method or formula to get the average age from this list. Can anybody help
please?
 
A

Andy Brown

How accurate/what format do you need? "What is a month?" gets complicated.

In A1:A5 I entered our birthdates. In B1, I entered
=YEARFRAC(A1,TODAY())

and dragged it down to B5. In B6, I entered

=AVERAGE(B1:B5)

HTH,
Andy
 
G

Guest

try using the yearfrac function to calculate the age of
each person from a date certain using a separate column,
then the average function
 
A

Andy Brown

NB -- for YEARFRAC, you'll need Analysis Toolpak (Tools -- Add-Ins). Sorry,
I always forget that.

Rgds,
Andy
 
D

Dave Peterson

Chip Pearson has some notes for =datedif() at:
http://www.cpearson.com/excel/datedif.htm

(Only documented in help in xl2k--but exists in all versions.)

=DATEDIF(AVERAGE(A1:x1),TODAY(),"y") & " years, "
& DATEDIF(AVERAGE(A1:x1),TODAY(),"ym") & " months, "
& DATEDIF(AVERAGE(A1:x1),TODAY(),"md") & " days"

(all one cell)
 
R

Ron Rosenfeld

I'm using Excel 2000.... I have a row of dates of birth. I would like a
method or formula to get the average age from this list. Can anybody help
please?
Click to expand...

Well, depending on the amount of accuracy you require, you could do something
like:

=(TODAY()-AVERAGE(1:1))/365.25

for dates of birth in row 1 and the result in years.


--ron
 
2

2rrs

Brian said:
I'm using Excel 2000.... I have a row of dates of birth. I would like a
method or formula to get the average age from this list. Can anybody help
please?
Click to expand...

Have you tried; AVERAGE(range)?
 
Top