Take a look at Chip Pearson's notes at:
http://www.cpearson.com/excel/datedif.htm

Pam wrote:

I am trying to figure out a formula that will calculate how many years &
months an employee has worked for the company. I found a formula that will
give me the years, but not years & months.

--

Dave Peterson