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
|