There are quite a few ways to do this, here's one:
=CONCATENATE(DATEDIF(A1,A2,"y"), " yr.s ", DATEDIF(A1,A2,"ym"), " mo.s")
where A1 contains DOB and A2 a subsequent date.
For an explanation of datedif function (only documented in XL 2000)
http://www.cpearson.com/Excel/datedif.aspx
Paul
"Dorothy A. Skenandore" wrote
in message ...
I need a formula for current age in years and months. I.E.
DOB Current AGe
10/09/08 = 4 mo.
11/05/03 = 5 yr.s 5 mo.s
04/05/09 = -2 mo.
For Excell 2003
--
Dot