formulas
 

How can I calculate age on an excel 2000 worksheet?

formulas
 

If you have a date of birth in cell A1

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=502701

formulas
 

See http://www.cpearson.com/excel/datedif.htm#Age

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"grammom45" wrote in message
...
How can I calculate age on an excel 2000 worksheet?