Absence Rates Turnover (Team) Calculator
Calculate your team's absence rate, employee turnover rate, and the working days lost during a chosen reporting period.
Overview
Use this team absence and turnover calculator to measure days lost to absence and the proportion of employees leaving during a reporting period. Enter your average team size, leavers, total absence days, and scheduled workdays per employee to produce comparable percentage measures.
How it works
The calculator estimates scheduled team workdays by multiplying average headcount by scheduled workdays per employee. It divides total absence days by those scheduled team workdays to calculate the absence rate. It calculates turnover by dividing the number of leavers by the average team headcount. Using consistent reporting periods and definitions makes the results more useful for tracking changes over time.
How to use this calculator
- 1Enter the average number of employees in the team for the reporting period.
- 2Add the number of employees who left the team during that period.
- 3Enter the total scheduled workdays lost to absence across the team.
- 4Enter the number of scheduled working days for one employee in the same period.
- 5Review the absence rate, turnover rate, and estimated available workdays.
Example Calculation
Average team headcount
20
Number of leavers
2
Total absence days
24
Working days per employee
65
Team absence rate
1.8%
With an average team of 20 employees, 2 leavers, and 24 absence days over 65 scheduled workdays per employee, the absence rate is about 1.8% and the turnover rate is 10.0%.
Frequently asked questions
How is team absence rate calculated?
Team absence rate equals total employee absence days divided by total scheduled team workdays, multiplied by 100.
How is employee turnover rate calculated?
This calculator divides the number of employees who left during the period by the average team headcount, then multiplies the result by 100.
What counts as an absence day?
Use scheduled workdays that were not worked because of absence under your organisation's reporting definition. Keep the definition consistent between periods.
Why use average headcount for turnover?
Average headcount provides a more representative denominator when team size changes during the reporting period.
Should annual leave be included in absence days?
Usually no. Annual leave is normally planned time away rather than absence, but use the definitions and policies applied by your organisation.
Can I compare absence and turnover across teams?
Yes, provided each team uses the same reporting period, working-day basis, absence definition, and method for calculating average headcount.
Explore Related Calculators
Assumptions and warnings
Assumptions
- The average headcount is representative of the team throughout the reporting period.
- Absence days are measured as scheduled employee workdays lost, not calendar days.
- Turnover is calculated using leavers divided by average team headcount.
- Results are period-specific; use the same reporting period when comparing teams or trends.
Warnings
- These results are management estimates and should be interpreted alongside workforce context, such as seasonal demand, restructures, and approved leave policies.