Hi Mike

here's a formula from Chip Pearson's web site
(http://www.cpearson.com/excel/datedif.htm#Age)

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

to use it with a given date (15 Dec 04) rather than the current date (Now())
use the following formula

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

where A1 stores their birthdate and B1 stores the date to compare to

Cheers
JulieD


"Mike New" <Mike wrote in message
...
I am trying to calculate chronological age - years and complete months -
for
school report purposes. I can get Years and months but not accurately -
say
for a date of birth 22nd November 1995 and a date of the 15th December - I
get 9 years and 1 month.