close

hi,
i don't know how to compute a date formula to display someone's age. it will
not let me subtract like a calculator and reveal the age. how do you enter a
formula to compute your age?

Use the DATEDIF function. E.g.,

=DATEDIF(birthdate, TODAY(), quot;yquot;)

See www.cpearson.com/excel/datedif.htm for more information about
DATEDIF.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

quot;heathquot; gt; wrote in message
...
gt; hi,
gt; i don't know how to compute a date formula to display someone's
gt; age. it will
gt; not let me subtract like a calculator and reveal the age. how
gt; do you enter a
gt; formula to compute your age?

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

    software

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