View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Average of dates of birth

Another option if you want the average age in whole years is
=DATEDIF(AVERAGE(A1:A155),TODAY(),"y")
--
David Biddulph

"John" wrote in message
...
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