formula to caluclate the # of years and months between two dates
 

This is a simple formula that gets years months and days, adjust as needed

=YEAR(B4)-YEAR(A4) & " years " & MONTH(B4)-MONTH(A4) & " months " &
DAY(B4)-DAY(A4) & " days"

A4 has the current date and A4 has begin date


"Christyepd" wrote:

I am setting up the employees lenths of service from the date hired until
present date.