Team Absence Rate and Turnover Formula
Learn how to calculate team absence rate, employee turnover rate, scheduled workdays, and attendance days for one reporting period.
This calculator turns team absence and leaver data into comparable workforce measures. It first estimates the workdays scheduled for the team, then shows the percentage lost to absence and the percentage of the average team size that left.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Team Absence Rate
Where:
Divide the team’s recorded absence days by its total scheduled workdays, then multiply by 100 to express the result as a percentage.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| absenceDays - Total absence days | Total scheduled employee workdays lost to recorded absence during the reporting period. | days |
| averageHeadcount - Average team headcount | The representative average number of employees in the team during the reporting period. | employees |
| workingDaysPerEmployee - Working days per employee | Scheduled working days for one full-time employee in the same reporting period. | days |
| leavers - Number of leavers | Employees who left the team during the reporting period. | employees |
| scheduledWorkDays - Scheduled team workdays | Estimated total workdays available to the team before absence is deducted. | days |
Step-by-Step Calculation
Find scheduled team workdays
Multiply average team size by scheduled days for one employee.
scheduledWorkDays = averageHeadcount * workingDaysPerEmployee
Calculate the absence rate
Divide absence days by scheduled team workdays and convert the result to a percentage.
absenceRate = (absenceDays / scheduledWorkDays) * 100
Calculate the turnover rate
Divide the number of leavers by average team headcount and convert the result to a percentage.
turnoverRate = (leavers / averageHeadcount) * 100
Estimate attendance days
Subtract recorded absence days from scheduled team workdays. The minimum result is zero.
attendanceDays = max(0, scheduledWorkDays - absenceDays)
Quarterly team absence and turnover example
Scheduled team workdays
20 * 65
1,300 days
Absence rate
(24 / 1,300) * 100
1.846%
Turnover rate
(2 / 20) * 100
10.0%
Estimated attendance days
1,300 - 24
1,276 days
Final Result
For the quarter, the team absence rate is 1.8%, the turnover rate is 10.0%, and estimated attendance is 1,276 days.
Assumptions
- ✓Average headcount reasonably represents the team throughout the reporting period.
- ✓Absence days are scheduled employee workdays lost, rather than calendar days.
- ✓The working-days input and absence total use the same reporting period.
- ✓Leavers are counted once and relate to the team being measured.
Limitations
- !The calculation does not explain the reasons, timing, or concentration of absence or leavers.
- !Part-time patterns, new starters, and changing hours can make one working-days-per-employee figure less precise.
- !A small team can show large percentage changes from only one absence episode or one leaver.
- !The results are management estimates, not a measure of productivity, employee wellbeing, or performance.
Common Mistakes to Avoid
Using calendar days instead of scheduled workdays in the absence total.
Comparing a monthly rate with a quarterly or annual rate without adjusting the reporting period.
Dividing leavers by the closing headcount instead of the average headcount used by this calculator.
Including planned annual leave as absence when the organisation’s reporting definition excludes it.
Entering absence days for a different team population than the headcount figure.
Using a full-time working-day count without considering a team with materially different work schedules.
Related Formulas
Frequently Asked Questions
What is the formula for team absence rate?
Team absence rate is total absence days divided by scheduled team workdays, multiplied by 100. Scheduled team workdays equal average headcount multiplied by working days per employee.
How is team turnover calculated?
The calculator divides the number of leavers during the reporting period by average team headcount, then multiplies by 100.
Why does the formula use average headcount?
Average headcount is often more representative than opening or closing headcount when the team size changed during the period.
How do I calculate estimated attendance days?
Subtract absence days from scheduled team workdays. The calculator prevents the result from going below zero.
Can an absence rate be more than 100%?
A result above 100% usually indicates that absence days and scheduled workdays were measured on different bases or that an input needs checking.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.