Employee Turnover Rate

Excel Formulas › HR & Payroll

All versionsAVERAGE

Turnover rate is separations divided by average headcount over a period, as a percentage. It’s the standard people-metric for retention — a simple division once you have the counts.

Quick formula: turnover for a period:
=separations / AVERAGE(beginning_headcount, ending_headcount)
Separations over the average of start and end headcount gives the turnover rate.

Functions used (tap for the full reference guide):

AVERAGE

The example

6 leavers, headcount 95→105.

AB
1ItemValue
2Separations6
3Avg headcount100 → 6.0%

The formula

The formula:

=B2 / AVERAGE(B4, B5) // leavers ÷ avg headcount

How it works

How it works:

  1. Count separations (voluntary + involuntary) in the period.
  2. Compute average headcount — usually AVERAGE(beginning, ending), or the mean of monthly headcounts for more accuracy.
  3. Divide separations by average headcount and format as a percentage.
  4. Annualize a monthly figure by multiplying by 12 (or scale a partial year up to a full year).

More accurate average headcount: averaging just the start and end can mislead if staffing swung mid-period. Averaging the monthly headcounts — =AVERAGE(Jan:Dec headcounts) — smooths that out and is the figure most HR systems report.

Try it: interactive demo

Live demo

Separations and headcounts.

Turnover:

Variations

Annualized

Monthly × 12:

=monthly_separations / avg_headcount * 12

Voluntary only

Regretted attrition:

=voluntary_separations / avg_headcount

Retention rate

The flip side:

=1 - turnover_rate

Pitfalls & errors

Zero headcount. An empty average gives #DIV/0! — ensure headcounts are entered.

Define separations. Decide whether transfers, retirements, and temps count before comparing periods.

Consistent period. Annualize monthly figures before comparing to annual benchmarks.

Practice workbook

📊
Download the free Employee Turnover Rate practice workbook
A turnover-rate sheet with the annualized, voluntary, and retention variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I calculate employee turnover rate in Excel?
Divide separations by average headcount: =separations / AVERAGE(beginning_headcount, ending_headcount), formatted as a percentage.
How do I annualize a monthly turnover rate?
Multiply the monthly rate by 12: =monthly_separations / avg_headcount * 12.
What's a more accurate average headcount?
Average the monthly headcounts across the period rather than just the start and end, which smooths out mid-period swings.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Average by group · Headcount by month · Percent change

Function references: AVERAGE