Average of dates of birth
Nice,I just learned something.
John
"smartin" wrote in message
...
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
|