This formula is supposed to calculate difference between today and date hired to give years and months of service. We can use the LENGTH function in Excel to calculate the total number of characters in different cells. DATEDIF E21TODAY y y DATEDIF E21TODAY ym m.
Select a blank cell next to the entry date for instance C2 and enter this formula DATEDIF B2NOW M B2 is the entry date of the employee and drag auto fill handle down to the cells you want to apply this formula.
Enter the formula DATEDIF C2D2y years. To calculate the tenure of a staff from entry date until now you can apply below formulas. YEARFRAC1-Jan-20181-Jan-2019 returns 1 YEARFRAC1-Jan-20181-Jul-2019 returns 15. Use DATEDIF again with ym to find months.