
To compute service time in Excel, the DATEDIF function is highly reliable. The basic formula =DATEDIF(start_date, end_date, "Y") calculates complete years. For a more detailed output showing both years and remaining months, combine =DATEDIF(start_date, end_date, "Y") & " years, " & DATEDIF(start_date, end_date, "YM") & " months," providing a full picture of service length.


