How to Calculate Employee Turnover Rate Using Excel Formulas

Employee turnover rate measures how effectively a company retains its valuable employees. What is meant by employee turnover? A high turnover rate indicates that a company either hires unfit workers or fails to retain them. Essentially, high staff turnover may result from poor working conditions, lack of advancement opportunities, below-average pay, etc. Employee churn poses a significant risk for companies, especially with the external rotation of essential line workers. Often, employee departures occur due to contract expiration or voluntary resignation.



How to Calculate Employee Turnover Percentage Using Excel Formulas

The chart below displays employee turnover data for a company over 12 months. The number of employees at the beginning of the month is adjusted by adding new hires and subtracting those who left the company.

Source Data Table:

MonthInitial Number of EmployeesNew EmployeesResignationsFinal Number of Employees
January625107628
February62827623
March62341626
April62663629
May62951633
June63352636
July63625633
August63335631
September63126627
October62742629
November629105634
December63482640
Average Monthly Employment630.75
Resignations46
Employee Turnover Rate Indicator7.29%

This method calculates the final number of employees:

employee turnover rate formula.

Download an example of the employee turnover rate formula in Excel download file

The turnover rate is the ratio of the number of employees who left the company to the average number of employees hired throughout the month. The AVERAGE function is used to calculate the average number of employees for the entire month. The total number of resignations is summed up using the SUM function (СУММ) and divided by the average number of employees.

The results of these calculations can be compared to the industry averages or companies of a similar profile. Turnover rates vary by industry, so simply comparing this metric to previous results could lead to incorrect decisions. Premature measures, such as internal employee rotation programs, may also be misapplied. While it’s not always necessary to calculate turnover rates for 12 months, doing so can smooth out seasonal fluctuations in resignations that might otherwise skew the results.