Use the DATEDIF command.

=DATEDIF(start_date, TODAY(),"y")

See www.cpearson.com/excel/datedif.htm for more info about
DATEDIF.


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



"Savage" wrote in message
...
Is there anyway of converting a date to the amount of years. I
have
employees years started posted and I want to convert to years
worked with the
company.

Thanks

Kevin