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
|