Home > Topics > excel > body text

How to calculate length of service in excel

coldplay.xixi
Release: 2023-01-13 00:41:12
Original
123506 people have browsed it

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.

How to calculate length of service in excel

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)

How to calculate length of service in excel

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

How to calculate length of service in excel

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

How to calculate length of service in excel

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

How to calculate length of service in excel

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;

How to calculate length of service in excel

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.

How to calculate length of service in excel

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template