date formulas

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(), "y")

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




"heath" <heath@discussions.microsoft.com> wrote in message
news:B1F70A21-FFCE-452A-8095-B0DA978C1236@microsoft.com...
> 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?