How to calculate working years in excel? |
您所在的位置:网站首页 › 在职年限怎么计算 › How to calculate working years in excel? |
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! |
今日新闻 |
点击排行 |
|
推荐新闻 |
图片新闻 |
|
专题文章 |
CopyRight 2018-2019 实验室设备网 版权所有 win10的实时保护怎么永久关闭 |