Attrition Rate Calculator

Form

Results

Attrition rate

0

1

What is Attrition Rate?

The attrition rate calculator compares employee departures during a period with the average headcount at the start and end of that period. It expresses the result as a percentage, making it easier to compare teams of different sizes or monitor a consistently defined workforce measure over time.

This page uses a broad departures-based formula. Some organizations reserve “attrition” for positions that are not replaced and use “turnover” for all employee separations. The calculator does not distinguish those definitions automatically. Decide which departures belong in your measure, state that definition in your report and apply it consistently to every period being compared.

2

How to Use This Calculator

  1. Choose a reporting period, such as one month, one quarter or one calendar year. All three inputs must refer to the same workforce population and the same period boundaries.
  2. Enter Employees at the start using the headcount on the opening date. Enter Employees at the end using the closing-date headcount, following the same rules for part-time staff, contractors and employees on leave.
  3. Enter Employees that left as the departures included in your chosen definition during the period. Do not substitute the net headcount reduction, because recruitment may have replaced some departures.
  4. Choose Calculate and read the percentage rounded to two decimals. Record the period length and departure definition beside the answer so the rate can be interpreted properly.
  5. If recruitment or restructuring was substantial, review a more frequent average headcount as a separate analysis. This page uses only two snapshots, which may not represent a workforce that changed sharply within the period.
3

Formula Used

Average headcount = (starting headcount + ending headcount) ÷ 2. Attrition rate = employees who left ÷ average headcount × 100%.
4

Variables Explained

ItemMeaning
Employees at the startThe number of employees in the defined population at the opening of the period. It is a count, rather than payroll expense or full-time equivalent hours unless your whole metric is explicitly defined that way.
Employees at the endThe count for the same population at the closing date, using the same inclusion rules as the starting count.
Employees that leftThe number of departures during the period under the reporting definition. Include each qualifying separation once and keep internal transfers consistent.
Average headcountThe arithmetic mean of the two supplied snapshots. At least one must be positive for the denominator to be nonzero.
RateDepartures relative to average workforce size, expressed as a percentage for the chosen period. The calculator does not annualize the result.
5

Worked Example

A company begins a year with 100 employees, ends with 90 and records 10 departures. Average headcount is (100 + 90) ÷ 2 = 95. The attrition rate is 10 ÷ 95 × 100 = 10.5263%, displayed as 10.53%.

Now suppose the company begins and ends with 100 employees but has 20 departures and hires 20 replacements. Net headcount change is zero, yet the departures-based rate is 20 ÷ 100 × 100 = 20%. Looking only at the difference between opening and closing headcount would miss the employee movement.

For a small team with 10 employees at both dates and two departures, the rate is also 20%. Its percentage matches the larger example, but the underlying count is much smaller. Include counts alongside percentages so readers can assess the scale of a change.

6

Why Use This Calculator?

A higher rate means more departures relative to the average headcount under the selected definition. It does not explain the reason for those departures or establish that a workforce practice is good or bad. Retirement, seasonal staffing, restructuring, voluntary resignations and dismissals can have very different meanings even when they produce the same arithmetic result.

Compare like periods and populations. A monthly rate and an annual rate are not directly interchangeable, and multiplying a monthly figure by 12 is only a rough extrapolation if workforce size and departures remain comparable. For a formal annual measure, use the actual annual counts and the organization’s chosen denominator.

The two-snapshot average is transparent but limited. If headcount doubled midyear and then returned to its starting level, the opening and closing counts would hide that movement. A monthly or daily average may better describe the exposure base. Keep the chosen method stable when reporting a trend, or explain any change in methodology.

7

Common Mistakes

    • Do not use start minus end as Employees that left when hiring, transfers or acquisitions affected headcount.
    • Do not compare a rate for one department with a company-wide rate without checking the population and departure definition.
    • Do not enter both headcounts as zero. The calculation would divide by zero and cannot produce a meaningful rate.
    • Do not call a percentage-point change a percentage change. Moving from 10% to 12% is a two-percentage-point increase, or a 20% relative increase.
8

Frequently Asked Questions

Can the rate exceed 100%?

It can under a departures-based measure when many positions turn over repeatedly while average headcount stays small. A result above 100% is a reason to inspect the period, counts and definition, but it is not mathematically impossible.

Should new hires be entered separately?

This form has no separate hiring field. Hiring affects the ending headcount, while departures are supplied directly. Keep a separate reconciliation of opening headcount plus hires minus departures and other movements to check the source data.

Are internal transfers departures?

That depends on the population being measured. A transfer may leave a department while remaining within the company. Define the boundary first and count the event consistently; the calculator cannot infer the organizational relationship.

Does a low rate prove strong employee retention?

It describes fewer counted departures relative to the denominator. It does not measure engagement, performance or the reasons employees remain. Use it with departure reasons, tenure patterns and other relevant evidence rather than as a complete assessment.

9

Sources & References