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?
- Nov 21 Wed 2007 20:40
date formulas
close
全站熱搜
留言列表
發表留言