I have aroster of players with thier date of births. I would like to
automatically add their ages in another column

Try this Formula, assuming that the dob is in cell A1

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

regards
Mukesh

"duke" wrote:

I have aroster of players with thier date of births. I would like to
automatically add their ages in another column

On Fri, 9 Sep 2005 19:47:02 -0700, "duke"
wrote:

I have aroster of players with thier date of births. I would like to
automatically add their ages in another column

=DATEDIF(dob,TODAY(),"y")

See http://www.cpearson.com/excel/datedif.htm for documentation of this
function.
--ron