Employee turnover rate formula
A turnover rate needs an exit count, a period and a population definition. For the worked example, use voluntary exits during one month divided by the average of opening and closing employee headcount.
Worked example
A fictional team starts the month with 80 employees and ends with 100. Six employees leave voluntarily. Average headcount is (80 + 100) / 2 = 90. Voluntary turnover is 6 / 90, or about 6.67%. Those figures are teaching inputs, not a benchmark.
In SQL, calculate the ratio of totals when you combine departments:
SELECT SUM(voluntary_exits)
/ NULLIF(SUM(opening + closing) / 2.0, 0) AS turnover_rate
FROM snapshots
WHERE month = '2026-06';
NULLIF leaves the rate undefined when the denominator is zero. Reporting zero would say that an eligible population had no exits, which is a different claim.
Turnover and retention
Retention follows the people present at the start. New hires can raise closing headcount, but they do not join that opening cohort. A retention rate therefore does not follow automatically by subtracting a turnover rate from 100%.
Check the period boundary too. This course includes exits on the first reporting day and excludes the first day of the next period. The employer’s end_date is the first day outside employment. A snapshot on that date excludes the person.
Practice the definition in the exercise above, then compare opening-cohort retention and the full HR analytics course.