Turnover Rate Calculator Excel: Formula & Template

This calculator works out your employee turnover rate as a percentage for a given period. You enter the number of employees at the start of the period, the number at the end, and the number of separations during that period; the calculator returns the turnover rate and the average number of employees. The standard formula used is: (Separations ÷ Average Number of Employees) × 100.

Formula

The turnover rate is calculated using the formula:

Turnover Rate (%) = (Number of Separations ÷ Average Number of Employees) × 100

Where:

• Number of Separations – total employees who left during the period (voluntary resignations, terminations, retirements, etc.).
• Average Number of Employees – (Employees at Start + Employees at End) ÷ 2. This is a common simplification; some organizations use a more precise monthly average.

The result is expressed as a percentage. For example, a 12% annual turnover means that, on average, 12 out of every 100 employees left during the year.

Worked Example

Using the default values from the calculator:

• Employees at start: 100
• Employees at end: 105
• Separations: 12

Step 1: Calculate the average number of employees.

(100 + 105) ÷ 2 = 205 ÷ 2 = 102.5

Step 2: Divide separations by the average.

12 ÷ 102.5 = 0.117073…

Step 3: Multiply by 100 to get the percentage.

0.117073 × 100 = 11.71%

So the turnover rate is 11.71%, rounded to two decimal places.

When to Use This Calculator

Use this calculator when you need a quick, consistent turnover figure for a specific period—monthly, quarterly, or annually. It’s most useful for:

• HR reporting and headcount planning.
• Comparing turnover across departments or teams (calculate separately for each).
• Benchmarking against industry averages (note that averages vary widely by sector).
• Tracking the effect of retention initiatives over time.

The result gives you a single number that summarizes how many people left relative to your average workforce size. A higher rate often indicates potential issues with engagement, compensation, or management, but context matters—seasonal industries and companies in growth mode naturally have higher turnover.

How to Build This in Excel (or Google Sheets)

You can replicate this calculator in a spreadsheet in minutes. Here’s how:

1. In cells A1, A2, and A3, enter the labels: “Employees at start,� “Employees at end,� and “Separations.�
2. In cells B1, B2, and B3, enter the numbers (e.g., 100, 105, 12).
3. In cell A5, type “Average employees� and in B5 enter: =(B1+B2)/2
4. In cell A6, type “Turnover rate� and in B6 enter: =(B3/B5)*100
5. Format B6 as a percentage if you prefer (or leave it as a number and add a % sign in the label).

For a monthly average that’s more precise, list headcount for each month in a column and use =AVERAGE(range) instead of just the start and end points.

Common Mistakes and Misconceptions

Mistake 1: Using only the ending headcount. Some people divide separations by the end-of-period headcount. This understates turnover when the company is growing and overstates it when shrinking. Always use the average.

Mistake 2: Counting all separations the same. Voluntary resignations, layoffs, and retirements are often analyzed separately. For retention analysis, you may want to exclude layoffs and transfers. The calculator gives you the overall rate; you can adapt it by entering only the separations you want to include.

Mistake 3: Ignoring the time period. A monthly turnover rate of 5% is not the same as an annual rate of 5%. Always state the period clearly. To annualize a monthly rate, you can multiply by 12, but this assumes constant monthly turnover—which is rarely true.

Misconception: “Low turnover is always good.� Very low turnover can indicate stagnation or poor performance management. The “ideal� rate depends on your industry, company stage, and role type.

Limitations of the Simple Formula

The formula above is the most common way to calculate turnover, but it has limitations:

• It treats all separations equally, regardless of whether they were voluntary or involuntary.
• It assumes linear headcount changes between start and end, which may not reflect reality.
• It doesn’t account for new hires who leave quickly (a common issue in high-volume hiring).
• It gives no insight into why people leave—that requires exit interviews and deeper analysis.

For a more detailed view, many HR teams calculate separate rates for voluntary turnover, involuntary turnover, first-year turnover, and department-level turnover. You can use this calculator for each subset by entering the relevant numbers.

Frequently Asked Questions

What is a good employee turnover rate? It varies by industry. As a rough guide, annual turnover of 10-15% is often considered healthy for stable industries, while retail and hospitality may see 60-70% or more. There is no universal “good� number—compare against your own historical data and industry benchmarks.

Should I include contractors and part-time workers? Decide based on your goal. If you’re measuring core workforce stability, include only employees (full-time and part-time) who are on your payroll. Contractors and temps are usually excluded, but if you’re analyzing total workforce churn, you might include them. Be consistent from period to period.

How do I calculate turnover for a specific department? Use the same formula but with the department’s start headcount, end headcount, and separations. For example, if a sales team started with 20 people, ended with 18, and 5 left, the average is 19 and the turnover is (5 ÷ 19) × 100 = 26.32%.

What’s the difference between turnover rate and attrition rate? In most contexts they are the same. Some organizations use “attrition� to mean natural reductions (retirement, resignation) and “turnover� to include all separations including layoffs. The formula is identical.

Can I use this calculator for monthly turnover and then annualize it? Yes, but be careful. If you calculate a monthly rate of 2%, multiplying by 12 gives 24%, which assumes the rate stays constant. A more accurate annual rate is calculated by using the full year’s data, not by extrapolating from one month.

Why does my Excel formula show a different result than this calculator? Likely because you used a different denominator. Check whether your Excel formula divides by end headcount instead of average headcount, or whether you formatted the result as a percentage (which multiplies by 100 automatically). This calculator uses the average headcount and returns a plain percentage number.

Related

• USA ZIP Code Distance Calculator: How It Works
• VAT Code Calculator: How to Find It
• Visual Basic Calculator Code: How to Build One

in start | Employees at start | - | 100 | 0
in end | Employees at end | - | 105 | 0
in seps | Separations during period | - | 12 | 0
out turnover | Turnover rate | % | (seps / ((start + end) / 2)) * 100 | 2
out avg_emp | Average employees | - | (start + end) / 2 | 1