Average Age

  • Thread starter Thread starter Brian
  • Start date Start date
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?
 
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
 
try using the yearfrac function to calculate the age of
each person from a date certain using a separate column,
then the average function
 
NB -- for YEARFRAC, you'll need Analysis Toolpak (Tools -- Add-Ins). Sorry,
I always forget that.

Rgds,
Andy
 
Back
Top