
Excel allows you to calculate years of service with the DATEDIF function. Use =DATEDIF(start_date, end_date, "Y") for full years only. For a detailed breakdown showing both years and remaining months, apply =DATEDIF(start_date, end_date, "Y") & " years, " & DATEDIF(start_date, end_date, "YM") & " months".


