Why you need this
Attrition Rate (or Turnover Rate) measures how many employees leave over a period.
Using the average headcount (Start+End)/2 gives a more accurate picture than just using the starting count.
One-Click Copy
=(Separations / ((StartHC + EndHC)/2)) * 100
Copy
Quick context
- • Works in both Excel and Google Sheets.
- • Use when you need consistent, auditable results.
- • Copy the snippet above and adjust only the ranges.
When to use
Learn how to use the Excel Attrition Rate Formula formula.
Disclaimer: While we strive for accuracy, these formulas are provided "as is" without warranty of any kind. Please verify all results before use.
Compliance Risk
Static HR reports can't handle date-effective changes. You need a real HRIS.
See hr Alternatives