Annual Absence Rate and Turnover Formula
Learn how annual employee turnover, absence rate, average headcount and absence days per employee are calculated.
This calculator estimates annual workforce turnover and absence using opening headcount, movements during the year and total absence days. Using average headcount makes the rates more representative when the workforce changes in size.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Annual Turnover Rate
Where:
Divide the number of employees who left during the year by the average number employed, then multiply by 100.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| startingHeadcount - Starting headcount | Number of employees at the beginning of the year. | employees |
| hires - Employees hired | Number of employees who joined during the year. | employees |
| leavers - Employees who left | Number of employees included as leavers under the chosen reporting definition. | employees |
| endingHeadcount - Ending headcount | Estimated workforce size at year end after hires and leavers. | employees |
| averageHeadcount - Average headcount | Average of opening and estimated closing headcount. | employees |
| workingDaysPerEmployee - Working days per employee | Scheduled workdays for a typical employee before absences. | days |
| totalAbsenceDays - Total absence days | Total scheduled workdays lost to the absence categories being measured. | days |
| availableWorkDays - Available work days | Estimated scheduled workdays for the average workforce. | days |
Step-by-Step Calculation
Estimate ending headcount
Add hires to the opening headcount and subtract employees who left.
endingHeadcount = startingHeadcount + hires - leavers
Calculate average headcount
Take the midpoint between opening and estimated closing headcount.
averageHeadcount = (startingHeadcount + endingHeadcount) / 2
Calculate annual turnover
Express leavers as a percentage of the average workforce.
annualTurnoverRate = (leavers / averageHeadcount) * 100
Estimate available work days
Multiply the average workforce by scheduled workdays per employee.
availableWorkDays = averageHeadcount * workingDaysPerEmployee
Calculate annual absence rate
Express total absence days as a percentage of estimated scheduled workdays.
annualAbsenceRate = (totalAbsenceDays / availableWorkDays) * 100
Calculate absence days per employee
Divide total absence days by the average workforce size.
averageAbsenceDaysPerEmployee = totalAbsenceDays / averageHeadcount
Example: stable workforce of around 100 employees
Ending headcount
100 + 15 - 15
100 employees
Average headcount
(100 + 100) / 2
100 employees
Annual turnover rate
(15 / 100) * 100
15.0%
Available work days
100 * 260
26,000 days
Annual absence rate
(500 / 26000) * 100
1.9%
Absence days per employee
500 / 100
5.0 days
Final Result
Estimated annual turnover rate: 15.0%. Estimated annual absence rate: 1.9%. Average absence: 5.0 days per employee.
Assumptions
- ✓Average headcount is the simple average of the opening and estimated closing headcount.
- ✓All employees are treated as having the same scheduled working-day pattern.
- ✓The total absence days use a consistent set of absence categories for the full year.
- ✓Leavers are counted once and are included according to the organisation's chosen reporting definition.
Limitations
- !A simple opening-to-closing average may not reflect large workforce changes that occurred partway through the year.
- !Part-time, seasonal, temporary and variable-hours employees may make a single working-days input less precise.
- !The calculation does not identify the cause, duration pattern or concentration of absences.
- !Results are management estimates and are not a benchmark or an assessment of workforce performance.
Common Mistakes to Avoid
Using year-end headcount instead of average headcount as the turnover denominator.
Counting internal transfers as leavers in one period but excluding them in another.
Including non-scheduled days in total absence days while using scheduled workdays as the denominator.
Using 260 workdays for employees who have materially different work patterns without adjusting the method.
Comparing departments that use different absence categories or leaver definitions.
Related Formulas
Frequently Asked Questions
What is the annual turnover rate formula?
Annual turnover rate equals leavers divided by average headcount, multiplied by 100.
How is average headcount calculated?
This calculator adds opening headcount to estimated closing headcount and divides the result by two.
What is the annual absence rate formula?
Annual absence rate equals total absence days divided by average headcount times scheduled workdays per employee, multiplied by 100.
Why are scheduled workdays used for absence rate?
They provide the estimated amount of work time that could have been worked before recorded absences.
Can turnover be more than 100%?
Yes. If leavers exceed average headcount over a year, often because roles were refilled repeatedly, the calculated rate can exceed 100%.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.