How to calculate working years in excel?
How to calculate working years in Excel:
1. Open Excel and create a workbook.
#2. Enter the original data. The first column is the employee's name, the second column is the employee's joining date, and the third column is the working years.
#3. Enter the formula =(TODAY()-B2)/365 in the cell of the working years column. The TODAY() function in the formula represents the current date.
#4. After entering the formula, press Enter to get the result.
#5. You can further set the number of decimal places for the result.
#6. The remaining cells will automatically get the corresponding results after being filled using the fill handle.
Recommended tutorial: "excel"
The above is the detailed content of How to calculate working years in excel?. For more information, please follow other related articles on the PHP Chinese website!