Country or region and language

    Choose your country or region and your language.

    Suggested for you

      All countries and regions

        Choose your character

        It shows in the top bar and on your profile. Change it any time.

        HR analytics course

        Voluntary turnover rate

        Opening HR analytics
        Your turn

        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.

        Your Work Gym account

        Save your progress and pick up on another device. Your browser's progress comes with you.

        or

        You can keep practicing without an account.

        Change your plan

        Checking the price

        Help and feedback

        Ask a question, tell us what is not working, or share an idea. We reply by email.

        What is it about?

        We use it only to reply to you.