Quarterly Turnover Rate Formula & How to Calculate It

This calculator works out your quarterly employee turnover rate: you enter the number of employees at the start of the quarter, the number at the end, and how many left during that quarter, and it returns the turnover percentage. It uses the standard formula that divides separations by the average workforce size, then multiplies by 100. The result tells you what fraction of your typical headcount walked out the door in those three months.

Formula

The quarterly turnover rate is calculated as:

Turnover Rate (%) = (Number of Separations ÷ Average Number of Employees) × 100

Where:

• Number of Separations – all employees who left during the quarter, including resignations, terminations, retirements, and layoffs (count each departure once).
• Average Number of Employees – typically (headcount at start of quarter + headcount at end of quarter) ÷ 2. Some HR teams use a monthly average for more precision.
• Quarterly turnover rate – expressed as a percentage, representing the proportion of your average workforce that left in that three-month period.

This is the same formula used for annual or monthly turnover, just applied to a three-month window. The result is a snapshot; it does not project yearly turnover by multiplying by four, because turnover patterns are rarely uniform.

Worked Example

Using the default values from the calculator above:

• Employees at start of quarter: 100
• Employees at end of quarter: 95
• Separations during quarter: 10

Step 1: Calculate the average number of employees.

(100 + 95) ÷ 2 = 195 ÷ 2 = 97.5

Step 2: Divide separations by the average.

10 ÷ 97.5 = 0.10256…

Step 3: Multiply by 100 to get a percentage.

0.10256 × 100 = 10.3% (rounded to one decimal place)

So the quarterly turnover rate is 10.3%. That means roughly one in ten of your typical workforce left during the quarter.

Why Use a Quarterly Rate Instead of Annual?

Quarterly turnover gives you a more current read on workforce stability than waiting for an annual figure. It’s especially useful for:

• Spotting seasonal patterns – retail, hospitality, and agriculture often see spikes in certain quarters.
• Measuring the impact of a new policy, manager, or compensation change within a short feedback loop.
• Comparing performance across teams or locations on a rolling basis.
• Early warning of retention problems before they become annual crises.

However, quarterly rates are more volatile than annual ones. A single large layoff or a hiring freeze can skew the number, so it’s best to look at several consecutive quarters to identify a trend.

How to Read the Result

A higher percentage means more people left relative to your workforce size. There is no universal “good” number – it depends on industry, region, and role type. For example, retail and food service often run higher turnover (50–100% annually) while utilities or government run much lower (5–10% annually). To interpret your quarterly rate:

• Compare it to your own historical quarters, not just to industry averages.
• Break it down by department or tenure – a 10% overall rate might hide a 30% rate among new hires.
• Separate voluntary departures (resignations) from involuntary ones (layoffs, terminations) – they have different causes and solutions.
• Consider whether your headcount is growing or shrinking – rapid growth lowers the rate even if the same number of people leave.

The rate is a lagging indicator: it tells you what already happened, not why it happened. Use exit interviews and stay interviews to understand the reasons behind the numbers.

Common Mistakes and Misconceptions

Several errors frequently distort turnover calculations:

• Using end-of-quarter headcount only – if your company is growing, this understates the average workforce and inflates the rate. Always use the average of start and end (or a monthly average).
• Counting new hires as separations – only count employees who actually left, not those who joined and stayed.
• Including internal transfers – moving from one department to another is not a separation from the company. Count only exits from the organization.
• Multiplying the quarterly rate by four – this assumes constant turnover all year, which is rarely true. If you want an annual projection, calculate it directly from annual data.
• Rounding too early – round only at the final step, as intermediate rounding can change the result by a few tenths of a percent.

Another common misconception is that turnover is always bad. Some turnover is healthy – low performers leaving, or employees moving on to better fits. The key is to track whether the leavers are your top performers and whether you’re losing critical skills.

Limitations of the Formula

The simple formula has real limitations. It treats all separations equally, so a resignation of a senior engineer counts the same as a seasonal temp finishing a contract. It also ignores the quality of leavers and the difficulty of replacing them. Additionally, the average headcount method assumes a linear change over the quarter, which may not reflect reality if hiring or departures are lumpy.

For a more nuanced view, consider these variations:

• Voluntary vs. involuntary turnover – calculate each separately to see if people are choosing to leave or being asked to leave.
• First-year turnover – count only those who leave within 12 months of hire; this is a key metric for onboarding effectiveness.
• Regretted turnover – track which leavers you wished had stayed; this is harder to measure but more actionable.
• Stability index – instead of separations, count employees with one or more years of service who remain; this measures retention of experienced staff.

No single formula captures the full picture, but the quarterly rate is a solid starting point for monitoring workforce trends.

Frequently Asked Questions

How do I calculate quarterly turnover rate in Excel?

In Excel, put your start headcount in A1, end headcount in A2, and separations in A3. Then use the formula: =A3/((A1+A2)/2)*100. Format the cell as a percentage if you prefer, or leave it as a number. This gives you the same result as the calculator above.

What is a good quarterly turnover rate?

There is no universal benchmark. A good rate depends on your industry and region. For example, retail and hospitality often see quarterly rates of 10–20%, while professional services might see 3–8%. The best comparison is your own historical data and industry-specific reports from HR associations.

Should I include contractors or temporary workers?

Only if you consistently count them in your headcount. The formula requires the same definition of “employee” in both the numerator (separations) and denominator (average headcount). If you include temps in headcount, include their departures too; otherwise, exclude both. Mixing definitions makes the rate meaningless.

How is quarterly turnover different from annual turnover?

Quarterly turnover measures separations over three months relative to the average headcount in that period. Annual turnover does the same over 12 months. They are not directly convertible by multiplying by four because turnover is not uniform across the year – for instance, many retail workers leave after the holiday season, so Q1 may be higher than other quarters.

What if I don’t know the headcount at the start of the quarter?

If you don’t have the exact start figure, use the end-of-previous-quarter headcount as a proxy. If that’s also missing, you can use the average of the end-of-quarter headcounts for the previous and current quarters, but note that this is less accurate. The more data points you have, the better the estimate.

Related

• Multiplying Fractions Hands-On Student Pack
• Volume of Prism: Formula, Examples & Calculator
• Buffer Preparation Calculator: Formula & How To Use

in start | Employees at start of quarter | - | 100 | 0
in end | Employees at end of quarter | - | 95 | 0
in sep | Separations during quarter | - | 10 | 0
out turnover | Quarterly turnover rate | % | (sep / ((start + end) / 2)) * 100 | 1