How To Calculate Employee Turnover In Excel

You can watch a video tutorial here.

Excel can be used for all types of calculations and can be used to create formulas. When creating a formula, it is better to use cell references so that the formula is dynamic and will be updated whenever the source values change. Employee turnover or attrition rate refers to the number of employees that leave an organization within a given period. It is usually computed for a year.
The formula is as follows:

Employee turnover = No. of employees who left * 100/Average employees

Step 1 – Calculate the average employees

– Select the cell where the result is to appear
– Type the formula using cell references:
=( No. of employees on 1-Jan-2021+ No. of employees on 31-Dec -2021)/2
– Press Enter

Step 2 – Create the formula

– Select the cell where the result is to appear
– Type the formula using cell references:
= No. of employees who resigned in 2021/ Average employees
– Press Enter