Formula for Calculating Length of Service in Microsoft Excel

Microsoft Excel Tips and Tricks

In this video I demonstrate how to calculate employees’ length of service using Microsoft Excel. You can do this a number of ways in Excel: in this video I cover the YEARFRAC and DATEDIF functions.

Credit Chester Tugwell