Site icon ProjInsights

How to Calculate Attrition Rate — Step by Step Guide

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:

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:

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:

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.

Please enable JavaScript in your browser to complete this form.

Exit mobile version