Hi,

use DATEDIF(A2,A3,TYPE)

Type = "Y" - if you are looking for the difference in complete Yeards
"M" diference in complete months
"D" diference in days
"MD" diference between dates but months and years are ignorated
"YD" diference between dates but days and years are ignorated

Does this helps?
thanks in advance for your feedback
regards from Brazil
Marcelo


"hellZg8" escreveu:

I'm looking for a way to find out how long an employee has been with the
company.

I enter the start date in one column and in the next column it has today's
date
then in the third column it has the difference between the two.

thanks in advance