:To find how many full years an employee has been with a company: =DATEDIF(A2, TODAY(), "Y") 4. Calculating Working Days Only
: If the result looks like a date (e.g., 1/9/1900 ), change the cell format to General or Number to see the total days. 2. Using the DAYS Function calculate the difference between two dates in excel
: If A1 is 1/1/2024 and B1 is 1/10/2024 , the formula =B1-A1 will return 9 . :To find how many full years an employee