How to calculate length of service in excel

How to calculate length of service in Excel: First select the first cell in the column of length of service, click [f(x)] to bring up the function input box; then search for the DATEDIF function and enter the start time and end time and the type of information required; finally click OK.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to calculate seniority in excel:

1. First of all, we need to have a certain understanding of the formula for calculating seniority in excel. The function used to calculate seniority is DATEDIF (starting Start date, deadline, required information type)

2. Take the table in the picture as an example, first select the first cell in the column of length of service, and click f(x) brings up the function input box

3. Search for the DATEDIF function in the pop-up function input window, and then click OK,

4. In the pop-up window, enter the start time, end time and required information type (comparison unit),

5. Start time For example, B2, use the TODAY() function for the cut-off time, write "Y" as the comparison unit, and then click OK. The age of the first worker will be calculated;

6. To calculate the length of service of everyone, we only need to move the mouse to the lower right corner of the first cell. As shown in the picture, the mouse turns into a black cross.

Related learning recommendations: excel tutorial

The above is the detailed content of How to calculate length of service in excel. For more information, please follow other related articles on the PHP Chinese website!