How to calculate the employee tenure in months or years in Excel?
As a human resource specialist, you may need to calculate every employee’s tenure in month or years for different salaries or treatments. Here I introduce some tricks on calculating the tenure in months or years in Excel.
To calculate the tenure of a staff from entry date until now, you can apply below formulas.
Select a blank cell next to the entry date, for instance, C2, and enter this formula =DATEDIF(B2,NOW(),"M"), B2 is the entry date of the employee, and drag auto fill handle down to the cells you want to apply this formula. See screenshot:
If you want to calculate the tenure in years, you can apply this formula =DATEDIF(B2,NOW(),"Y"), see screenshot:
If you want to calculate the specific years and months of tenure, apply this formula =DATEDIF(B2,C2,"y") & " years, " & DATEDIF(B2,C2,"ym") & " months ", B2 is the entry date, and C2 is the leave date. See screenshot:
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
- To post as a guest, your comment is unpublished.· 8 months agoi have date of joining and 26 oct 2010 and service years is 5.01 so how i calculate date of leaving like date of joinig format
- To post as a guest, your comment is unpublished.· 10 months agoHI
How do I calculate Man Month for a Turn-key Construction Project which has a timeline to be completed in 06 Weeks!!!
- To post as a guest, your comment is unpublished.· 1 years agoHow to calculate total service period of an employee excluding the extra day count of leap years in excel ? eg; (Period : 01-11-1999 to 08-08-2019)