=DATEDIF(A2,A1,"Y") & " Years, " & DATEDIF(A2,A1,"YM") & " Months, " &
DATEDIF(A2,A1,"MD") & " Days"

Would this do?

"Nicky" wrote:

I want to find out how old a person is.
A1 is todays date 2007/2/22 and A2 is their birthday 1975/04/22.Both cells
are in date format.I say A1-A2 the answer appears as a date and when I change
it to a number I get 11629 which is WRONG. It should equal 31.
Pls help!