How to Calculate Attrition Rate — Step by Step Guide
| Getting your Trinity Audio player ready... |
If you manage a team or run HR for a company, attrition is one of those numbers that can quietly spiral out of control before anyone notices. The good news? Calculating it takes less than five minutes once you know the right formula — and tracking it consistently makes all the difference.
What Is Attrition Rate?
Attrition rate measures the percentage of employees who leave your organisation over a given period — and aren’t immediately replaced. It covers voluntary exits (resignations), involuntary exits (terminations), retirements, and any other departures.
It’s different from turnover, which includes roles you actively backfill. Attrition specifically tracks the shrinkage of your headcount — and it’s a key metric for audits, workforce planning, and leadership reporting.
If you’re ready to run the numbers straight away, use our free Attrition Rate Calculator — it calculates overall, voluntary, involuntary, and regrettable attrition rates instantly.
→ Try the free Attrition Calculator on ProjInsights
The Attrition Rate Formula
The SHRM-standard formula used globally is:
Attrition Rate = (Total Separations ÷ Average Headcount) × 100
Where:
- Average Headcount = (Opening headcount + Closing headcount) ÷ 2
- Total Separations = all exits in the period (voluntary + involuntary)
Example: If you started the quarter with 500 employees, ended with 480, and had 38 exits — your attrition rate is (38 ÷ 490) × 100 = 7.8%.
Why Tracking Attrition Properly Matters
Most teams make two common mistakes: using the wrong formula (opening headcount only instead of average), or calculating a single number without breaking it down. A 12% overall rate tells you very little. A 12% rate where 9% is regrettable exits — high performers who chose to leave — tells you something urgent.
For audit purposes, you need to track:
- Voluntary vs. involuntary attrition separately
- Regrettable vs. non-regrettable exits
- Retention rate alongside attrition (they tell different stories to the board)
- Cost of attrition — so leadership can put a dollar figure on it
Without a consistent method, HR, Finance, and Operations end up with different numbers for the same period — which is exactly what auditors flag.
Calculate Yours in Under 2 Minutes — Free Tool
We built a free, audit-grade attrition calculator that does the heavy lifting for you. No spreadsheets, no manual formulas. Just enter your headcount and exit data and it instantly calculates:
- Overall, voluntary, involuntary, and regrettable attrition rates
- Retention rate (the number your board responds to)
- Total cost of attrition for your leadership report
- Hiring targets to maintain or grow headcount
- Multi-department comparison in one view
- Full formula transparency and audit trail
It also supports CSV import from Excel or your HRIS so you can build a real monthly trend — not a simulated one.
Put these formulas to work immediately using our interactive Attrition Rate Calculator — no spreadsheet needed.
→ Try the free Attrition Calculator on ProjInsights
Common Questions
What’s a good attrition rate?
It depends entirely on your industry, region, and role type. Rather than chasing a generic benchmark, set your own internal target — ideally approved by leadership — and measure every period against that. Gallup considers anything below 10% annually to be healthy as a general rule.
What’s the difference between attrition and turnover?
Attrition refers to employees leaving without being replaced — your headcount shrinks. Turnover includes roles you actively backfill. For workforce planning purposes, you need both figures tracked separately.
How often should I calculate attrition?
Monthly for operational teams, quarterly for leadership reviews, and annually for audit and board reporting. Our calculator supports all three period types and annualizes rates automatically so you can compare across periods fairly.
Attrition is one of those metrics where the cost of not tracking it properly is always higher than the effort of doing it right. Start with the formula above, or save yourself the spreadsheet and use the free calculator — built specifically for teams and companies who need an audit-ready report, not just a number.
For more project management resources, in-depth guides, templates, and practitioner insights, visit projinsights.com — your go-to destination for modern project management knowledge, built for practitioners by practitioners.
