close

How can I calculate age on an excel 2000 worksheet?


If you have a date of birth in cell A1

=DATEDIF(A1,TODAY(),quot;yquot;)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=502701See www.cpearson.com/excel/datedif.htm#Age

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;grammom45quot; gt; wrote in message
...
gt; How can I calculate age on an excel 2000 worksheet?

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()