View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Average of dates of birth

If you have the dates in A1:A155 then this will give you the average age on
today's date

=TODAY()-AVERAGE(A1:A155)

"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