You can 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
"devinm21" wrote in message
...
If I have a person's birthday, how can I calculate their
current age based on
today's date?
Thanks!