Joe,

Use the DATEDIF function. E.g.,

=DATEDIF(birthdate,TODAY(),"Y")

For more information on DATEDIF, see
www.cpearson.com/excel/datedif.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Joe S." wrote in message
...
How to calculate ages of employees for benefits enrollment
given the date of
birth?
--
Joe S.