Attrition Rate Calculator

How to use and interpret the attrition rate

This calculator estimates the share of an organization’s average workforce that left during a defined measurement period. It follows the standard approach of dividing departures by average headcount, where average headcount is the arithmetic mean of opening and closing employee counts. The result is a period-specific percentage: a monthly calculation is a monthly rate, a quarterly calculation is a quarterly rate, and an annual calculation is an annual rate. The tool does not annualize shorter periods because doing so can exaggerate temporary spikes.

Enter one consistent measurement period

Measurement period is a report label rather than a mathematical input. Choose Monthly, Quarterly, Annual, or Custom period so exported summaries are clear. Every count must refer to that same period. A common mistake is combining a January opening headcount, a December closing headcount, and departures from only the latest quarter. That produces a percentage with no coherent interpretation.

Employees at the start is the number of active employees on the first day. Use a non-negative whole number and apply your organization’s normal headcount rules consistently. Decide whether contractors, interns, employees on long leave, and contingent workers belong in the population before collecting the data. A higher opening count generally raises average headcount and, all else equal, lowers the measured attrition rate.

Employees at the end is the active headcount on the final day. It has the same inclusion rules as the opening count. A higher ending count raises average headcount and therefore lowers the rate when departures are unchanged. Closing headcount alone does not reveal how much movement occurred: a company may finish at the same size after many departures and replacements.

Employees who left includes departures recorded during the period. Organizations may track voluntary resignations, involuntary terminations, retirements, deaths, and internal transfers separately, but the total used here must follow one documented policy. Increasing departures raises the attrition rate directly. Do not enter a decimal or a negative number, and do not count the same employee twice.

Understand every result

Attrition rate is the primary result. A value of 0% means no departures were recorded while average headcount was above zero. A higher value means departures were large relative to the workforce exposed during the period. The percentage can exceed 100% when departures are greater than average headcount, which may happen in highly seasonal operations or when many positions turn over more than once. Such a result is mathematically possible but should trigger a data-definition review.

Average headcount is the denominator: opening headcount plus closing headcount, divided by two. It is a simple approximation of workforce exposure. When headcount changes sharply during the period, a more granular average based on monthly or daily snapshots can be more representative, but the start/end method remains useful when only two snapshots are available.

Net headcount change equals closing headcount minus opening headcount. A positive number indicates growth, a negative number indicates contraction, and zero indicates the organization finished at the same size. Net change and attrition answer different questions: net change describes size, while attrition describes departures.

Implied additions is the balancing figure required to reconcile the workforce: closing headcount minus opening headcount plus departures. It can include hires, rehires, acquisitions, or transfers into the measured population. If this value is negative, the entered departures are not sufficient to explain the observed headcount decline; the calculator then labels the balance as an unrecorded reduction. That usually signals missing departure records, a changed population definition, or a scope mismatch.

Replacement ratio divides implied additions by recorded departures when departures are above zero and the reconciliation is valid. A ratio of 100% means one addition was implied for every departure. Below 100% means the organization replaced fewer people than it lost; above 100% means additions exceeded departures. This is a descriptive ratio, not a target.

Read the chart and calculation table

The bar chart compares opening headcount, average headcount, closing headcount, departures, and the balancing movement. Bar heights are scaled to the largest current value, while the adjacent legend provides exact values. The calculation table shows the same data plus formulas and interpretation fields. Because the chart, table, live results, and Excel workbook all use one calculation model, a change to any input updates every representation together.

Formula, controls, and practical cautions

The core formula is: attrition rate = departures ÷ ((opening headcount + closing headcount) ÷ 2) × 100. The denominator must be greater than zero. Empty fields, negative numbers, decimals, and nonnumeric values are rejected. Reset clears the inputs and replaces charts with a compact empty state. Download Excel creates a current-state workbook containing Summary, Inputs, Breakdown, Calculation Detail, and Notes sheets.

Use the rate as a trend metric rather than an isolated verdict. Compare periods of equal length, keep workforce definitions stable, and segment departures by department, tenure, role, location, or voluntary status when the aggregate rate masks operational differences. The U.S. Bureau of Labor Statistics publishes Job Openings and Labor Turnover Survey data for broader labor-market context. The UK Office for National Statistics provides a current labour market overview. For retention practice and terminology, consult the CIPD employee turnover and retention factsheet and the SHRM employee relations resources.

Attrition metrics support workforce planning, but they do not explain why people leave. Combine the percentage with exit interviews, engagement data, manager-level patterns, compensation reviews, and hiring-quality measures. Avoid comparing raw rates across industries or countries without accounting for seasonality, labor-market structure, workforce mix, and the precise departure definition used.