Absence Rate Formula
Learn how to calculate an employee absence rate from absence days, average headcount and scheduled working days.
An absence rate shows the share of scheduled working time lost to employee absence in a reporting period. Using available working days as the calculation base helps make results comparable across teams or periods of different sizes.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Absence Rate
Where:
First multiply the average number of employees by their scheduled working days. Divide total absence days by that workforce total, then multiply by 100 to express the result as a percentage.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| absenceDays - Total absence days | The total scheduled working days lost to absence during the measurement period. | days |
| employeeCount - Average number of employees | The average workforce headcount during the same measurement period. | number |
| workingDaysPerEmployee - Working days per employee | Scheduled working days for one employee in the period, excluding non-working days. | days |
| availableWorkingDays - Total available working days | The total scheduled employee-days available across the workforce. | days |
Step-by-Step Calculation
Choose one reporting period
Use matching monthly, quarterly or annual figures so the numerator and denominator cover the same dates.
period = same period for all inputs
Calculate available working days
This gives the total scheduled working days across the workforce.
availableWorkingDays = employeeCount * workingDaysPerEmployee
Calculate the lost-time fraction
This measures the share of scheduled working time that was lost to absence.
absenceFraction = absenceDays / availableWorkingDays
Convert the fraction to a percentage
Multiplying by 100 expresses the absence fraction as a percentage.
absenceRate = absenceFraction * 100
Calculate average absence per employee
This supporting figure shows average days lost per employee in the period.
averageAbsenceDays = absenceDays / employeeCount
Annual absence rate for a 120-person workforce
Calculate available working days
120 × 260
31,200 days
Divide absence days by available days
780 ÷ 31,200
0.025
Convert to a percentage
0.025 × 100
2.50%
Calculate average absence days
780 ÷ 120
6.5 days per employee
Final Result
The workforce absence rate is 2.50%, based on 780 absence days out of 31,200 available working days.
Assumptions
- ✓Absence days represent scheduled working days lost, rather than calendar days.
- ✓All inputs relate to the same reporting period.
- ✓The average employee count reasonably represents workforce size during the period.
- ✓Each employee is treated as having the stated number of scheduled working days unless the figures have already been adjusted for individual work patterns.
Limitations
- !The rate measures time lost but does not identify the causes, frequency or duration pattern of absences.
- !Part-time schedules, new starters and leavers can distort the result if available working days are not adjusted.
- !Different organisations may classify absence types differently, which can limit external comparisons.
- !A percentage alone does not show the operational, financial or wellbeing impact of absence.
Common Mistakes to Avoid
Using calendar days instead of scheduled working days.
Comparing a monthly rate with an annual rate without considering different reporting periods.
Using end-of-period headcount instead of average headcount when workforce size changed substantially.
Including annual leave or other planned non-working time as absence without applying a consistent definition.
Entering total workforce working days as working days per employee, which double-counts the denominator.
Related Formulas
Frequently Asked Questions
What is the formula for employee absence rate?
Divide total absence days by total available working days and multiply by 100. Total available working days equal average headcount multiplied by scheduled working days per employee.
How do I calculate total available working days?
Multiply the average number of employees by the scheduled working days per employee for the same reporting period.
How do I calculate average absence days per employee?
Divide total absence days by the average number of employees in the reporting period.
Should annual leave be included in absence days?
Planned annual leave is generally treated separately from absence. Apply your organisation's reporting definition consistently.
Can I calculate absence rate monthly or quarterly?
Yes. Use absence days, average headcount and scheduled working days that all relate to the same month or quarter.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.