View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default Average of dates of birth

Hi Greg
Say you have date of Birth : 1-Jan-60 in cell A1,:
=DATEDIF(A1,TODAY(),"y") result 49
=DATEDIF(A1,TODAY(),"m") result 588 (months) and you could have it in days
if you like. you need to use a column and drag down one of these formula,
then use Average(range)
HTH
John

"Greg" wrote in message
...
I am trying to determine the average age of 155 people from their 155 dates
of birth. How do I do it?
tks,
jgn