View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
smartin smartin is offline
external usenet poster
 
Posts: 915
Default 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