Workforce tools
Attrition rate calculator
Free employee attrition rate calculator — learn how to calculate attrition rate in seconds. Enter employees at start, employees at end, and departures to see attrition %, retention rate, average headcount, and compound annualized attrition (monthly, quarterly, or annual inputs). Industry benchmarks for hospitality, retail, healthcare, and office teams. Export CSV or PDF when you are done.
What this attrition rate calculator does
This employee attrition rate calculator measures how many people left relative to average headcount in a period. Enter employees at start, employees at end, and departures to get attrition %, retention %, and compound annualized attrition.
Unlike customer churn (subscriptions lost), workforce attrition uses average headcount in the denominator — the standard HR formula used in most workforce planning guides.
You get period-aware math (monthly, quarterly, or annual inputs), industry benchmark verdicts for shift-heavy teams, and export — built for people managers and ops leads, not SaaS logo churn.
Average-headcount formula
Standard HR attrition: departures ÷ average headcount × 100.
Industry benchmarks
Hospitality, healthcare, logistics, and office planning ranges with a health verdict.
Retention & annualization
Retention % plus compound annualized attrition — not naive period × 12.
CSV/PDF export
Download inputs and results for site reviews, board decks, or Excel.
Related workforce tools: employee cost calculator, time card calculator. For customer churn, use the churn rate calculator.
Attrition rate formula
The standard employee attrition rate formula (also called the attrition rate formula in HR) is:
Attrition rate (%) = (Departures ÷ Average headcount) × 100
Average headcount = (Employees at start + Employees at end) ÷ 2
Worked example: 150 employees at start, 140 at end, 18 departures → average headcount = 145 → attrition = (18 ÷ 145) × 100 ≈ 12.4%. Use the calculator above for live results and compound annual attrition when your inputs cover a month or quarter.
Enter headcount at start and end
Use the same period window — month, quarter, or year — for both counts.
Enter departures
Count employees who left during that period (voluntary and involuntary unless you filter).
Read your results
Review attrition %, retention %, annualized attrition, benchmark verdict, and optional export.
Attrition vs turnover vs customer churn
Three different metrics
Employee attrition rate and turnover rate often use the same formula (departures ÷ average headcount). Some HR vendors define attrition as roles left unfilled — document your rule and keep site reports comparable.
Customer churn is a different metric: lost paying subscribers ÷ customers at start. Use our churn rate calculator for SaaS — not this page.
Annual attrition is not monthly attrition × 12
Use compound annualization
A 2% monthly attrition rate compounds to about 22% annual attrition, not 24% (2 × 12). Formula: Annual attrition = [1 − (1 − period rate)n] × 100 where n is periods per year.
The calculator shows both compound annualized attrition and a naive × periods contrast so you can spot spreadsheet mistakes.
What is a good attrition rate?
| Industry / team type | Healthy annual max (planning guide) |
|---|---|
| Hospitality & retail | Up to ~25% |
| Healthcare | Up to ~15% |
| Logistics & warehouse | Up to ~20% |
| Office & professional | Up to ~10% |
Benchmarks are planning guides, not laws. Compare yourself to your own trailing twelve months and peer sites first. A 10% annual rate means different things for a stable office team vs a seasonal restaurant — use the industry selector for context, then investigate voluntary vs involuntary exits separately.
How to calculate attrition rate in Excel
To build an attrition rate calculator in Excel or Google Sheets:
- A1 — employees at start
- B1 — employees at end
- C1 — departures
- D1 — average headcount:
=(A1+B1)/2 - E1 — attrition %:
=IF(D1>0, C1/D1*100, "")
Prefer not to build the sheet? Use this calculator, then export CSV — inputs, average headcount, attrition, retention, and benchmark verdict are included.
Why attrition matters for shift teams
Shift operations feel attrition immediately: open shifts, overtime cover, and managers on the floor. Track attrition monthly alongside absence, overtime, and early attrition (exits in the first 90 days).
How to prevent employee attrition on hourly teams: publish rotas early, limit surprise schedule changes, run structured first-week onboarding, and track overtime before burnout. Fair employee scheduling and honest time tracking help you spot overload before people quit.
For a deeper guide — voluntary vs involuntary exits, tenure mix, and site-level benchmarks — document your definitions and compare sites monthly rather than relying on a single headline rate.
More free tools
Discover more calculators for time tracking, payroll, and HR.
Frequently asked questions about this attrition rate calculator
How do you calculate attrition rate?
Divide departures during the period by average headcount, then multiply by 100. Average headcount = (start + end) ÷ 2. Example: 18 departures ÷ 145 average = 12.4% attrition.
What is the attrition rate formula?
Attrition rate (%) = (Number of departures ÷ Average headcount) × 100, where average headcount = (employees at start + employees at end) ÷ 2.
Is 20% attrition rate high?
It depends on the period and industry. 20% annual attrition is high for stable office teams but can be normal in hospitality or retail if you segment correctly. 20% monthly would be extreme — recheck your period length.
What does a 10% attrition rate mean?
About 10% of average headcount left during the period you measured. If that is annual attrition for an office team, retention is roughly 90% — often a reasonable planning range. Context (voluntary vs involuntary, early exits) matters more than the headline number alone.
What does 80% attrition rate mean?
Usually a data error, a very small team, or a crisis period — not a typical steady-state rate. Recheck headcount, period length, and whether departures were double-counted before presenting 80% to leadership.
What is a good attrition rate for a company?
There is no single number for every employer. Many HR sources cite ~10% annual attrition or below as healthy for stable office teams, while hospitality and retail often run higher. Use the industry selector in this calculator, then compare your own trailing twelve months — a “good” rate depends on voluntary vs involuntary mix and early exits, not the headline % alone.
Attrition rate vs turnover rate — what's the difference?
In everyday HR usage they often mean the same formula. Some vendors define attrition as roles left unfilled and turnover as roles that were backfilled. Pick one definition and document it.
How is employee attrition different from customer churn?
Employee attrition measures people leaving your workforce (average headcount denominator). Customer churn measures lost subscribers (start-of-period denominator). Use this calculator for HR; use the churn rate calculator for SaaS.
How to calculate attrition rate in Excel?
Average headcount: =(A1+B1)/2. Attrition %: =IF(D1>0, C1/D1*100, "") where C1 is departures and D1 is average headcount. Or export CSV from this calculator.
How to calculate monthly attrition rate?
Use the same formula with a one-month window: start headcount at month open, end headcount at month close, departures during that month. Select Monthly in the period dropdown for annualization context.
Is annual attrition just monthly attrition × 12?
No. Attrition compounds on a shrinking base. 2% monthly ≈ 22% annual using compound math, not 24%.
What counts as a departure in attrition rate?
Usually resignations, retirements, dismissals, and redundancies — unless you report voluntary-only. Exclude offer declines and internal transfers unless your policy includes them.
What is a bad attrition rate for a company?
Context matters, but sustained annual attrition above ~20% is often a red flag for stable teams — and monthly attrition above ~2% usually deserves an immediate review. Rates near 80% are almost always a data error, a micro-team, or a crisis period. Segment by site, role, and tenure before labeling a rate “bad.”
How do you calculate attrition vs turnover?
When both use the same formula (departures ÷ average headcount × 100), the math is identical — only the label differs. Some HRIS vendors define turnover as backfilled roles and attrition as unfilled exits. Pick one definition, document it, and use the same inputs in this calculator either way.
How do you prevent employee attrition?
Start with diagnosis: short exit notes by site and shift pattern. Then focus on levers you control weekly — fair scheduling (published rotas, balanced unpopular shifts), first-90-day onboarding, honest time tracking so overtime shows up early, and manager check-ins when one team’s rate spikes. Pay matters, but schedule predictability often explains why two similar-wage sites show different attrition.