Thanks, this was very helpful. Am now trying to sort the newly calculated
ages in ascending order, and get #REF. Can you help?

"Gary''s Student" wrote:

If D.O.B is in A1 then:

=DATEDIF(A1,TODAY(),"y") & " years, " & DATEDIF(A1,TODAY(),"ym") & " months,
" & DATEDIF(A1,TODAY(),"md") & " days"

will give age. for example if A1 contains:
1/15/1985
the formula will return:
21 years, 8 months, 15 days

--
Gary''s Student


"smudge" wrote:

I'm setting up a spreadsheet which contains peoples names and Dates of Birth.
I need to had to have a formula that will calculate and display indiviuals
current AGE, from D.O.B.