formulas

[grammom45]

How can I calculate age on an excel 2000 worksheet?

 

[daddylonglegs]

If you have a date of birth in cell A1

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

 

[Bob Phillips]

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)