How to use the function in excel to calculate the length of service

The operation steps of "using functions in excel to calculate length of service" are as follows:

1, taking Excel 20 16 as an example, open the Excel worksheet;

2. The length of service is generally displayed throughout the year, because different dates will return different lengths of service. The DATEDIF function can calculate the number of years between two days according to the start date of employment and the current date or the end date of a specified date.

3. Enter the following formula in cell C2, and then fill the formula down.

=DATEDIF(B2, today (), "y")

Formula: take cell B2 as the start date and system date as the end time, and return the number of years between them.

4. Precautions:

The DATEDIF function can easily return the year, month and day of the year, or the year and day of the year, or the year and month of the year, but you need to put the start date in the first parameter position and set the third parameter to y, m, d, yd and ym respectively.