Free calculator
Staff turnover rate calculator (employee & average headcount)
Turn separations in a period and average employee headcount (or beginning and ending headcounts) into a turnover %. This is workforce turnover for the same period—not revenue “turnover”, not inventory turnover, and not a turnover cost or legal‑rules engine—see methodology and FAQ.
When to use this calculator
A one‑line people turnover % to match a classroom or handbook definition of (separations ÷ average headcount) × 100—before a big workforce model in Google Sheets or Excel.
- Track exits during a calendar year or your fiscal year, with headcount from a simple (begin + end) ÷ 2 average on the second tab.
- Sanity‑check a KPI slide: same numerator and denominator rules as a BambooHR-style explainer, without signing into HR software here.
- Copy a (S ÷ A) × 100 pattern into a row so a workbook matches the on‑page definition.
- Jump to the Net Promoter tool when the question is 0–10 recommendation counts, or the percentage tool for a plain part‑of‑a‑whole percent—a different metric from headcount turnover here.
We use the common (separations ÷ average employees) × 100 form for a workforce context—people leaving ÷ a time‑aligned headcount story—not revenue “turnover” and not inventory turns.
Workforce turnover %
Let S = number of separations (by your policy) in the period, A = average headcount in the same period. We show (S ÷ A) × 100. The result is a %; it can exceed 100% in edge cases when S > A on a small base—see the note in results and your own window rules.
Average from B and E (second tab)
We use (B + E) ÷ 2 to get A from headcount at the start and end of the same window as S—a simple teaching average; your HRIS may use monthly or FTE averages instead.
What this page is not
Revenue or inventory “turnover”, cost of turnover dollars, voluntary vs involuntary splits, FTE vs head policy details, and jurisdiction‑specific labor reporting. See FAQ for the people vs inventory distinction.
Align S and A to one policy line so an answer matches your report. For 0–10 survey buckets and NPS math, use the Net Promoter Score (NPS) calculator—a different kind of score from separations ÷ headcount here. For a generic x is what % of y (not headcount turnover by definition), open the percentage calculator.
Google Sheets & Excel
Put separations in one cell and your A in another, or use (B + E) ÷ 2 in its own cell. English U.S. / U.K. names; other languages: local function names in your file.
=S2/A2*100Format as % (or use 0.1 in the cell) so 0.1 = 10% depending on your number format.
=(B2+E2)/2Then set A2 to that cell (or a named range) in the first formula, or use =S2/((B2+E2)/2)*100 in a single line.
More tools in Unit economics
Browse all toolsSlide 1 of 16
Frequently asked questions
What is staff (employee) turnover rate?
Here it is a % of (separations in a period) ÷ (average headcount in that same period), often written from (beginning + ending) headcount ÷ 2 for A when you do not already have a monthly or FTE average from a system of record. It is not a moral or legal judgment—just a KPI definition to apply consistently.
What is the formula you use on this page?
Turnover % = (S ÷ A) × 100 with S = count of separations you count in the window, A = average number of employees in the same window. The “beginning/ending” path uses A = (B + E) ÷ 2.
Is this the same as “inventory turnover”?
No. Inventory and revenue “turnover” are other business metrics with very different numerators and denominators. This page is workforce (people) only.
What is a “good employee turnover rate?
“Good” depends on industry, role mix, location, and your own plan—there is no universal number here. Use this tool for a definition‑aligned %, not a promise of healthy HR in every case.
What about monthly vs annual windows?
Type S and A (or B and E) for one period you have in mind (for example a full year or a quarter). This page does not “annualize” a partial window in v1—if you need a 12‑month view from rolling data, do that in your HR system or a sheet you control so your start and end dates are explicit.
How do I match this in Google Sheets or Microsoft Excel?
Put separations in one cell, A in another, then =S/A*100 (or use % number format). If you only have B and E, set = (B + E) / 2 for A first, or one cell =S/((B+E)/2)*100—see the copy cards on this page.
Is this the same as the Net Promoter calculator?
No. NPS is from 0–10 survey buckets; this page is separations and headcount over a time window—a people counting line, not a recommendation score.
Is this HR or legal advice?
No. It is a free educational calculator and illustration on math and common definitions—not a policy for your jurisdiction and not a substitute for qualified HR or legal help when you need it.