Absence Rate Formula
Learn how to calculate employee absence and attendance rates from scheduled workdays and recorded absence days.
The absence rate shows the share of scheduled employee work time lost to recorded absence. The attendance rate shows the remaining share of scheduled time attended. Both measures use scheduled workdays rather than calendar days, making them useful for reviewing a team, department, or whole workforce over a consistent reporting period.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Absence Rate
Where:
First calculate all workdays the group was scheduled to work. Then divide recorded absence days by that total and multiply by 100.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| absenceDays - Total absence days | The total full-day or part-day equivalent absences recorded for the group. | days |
| employeeCount - Number of employees | The average number of employees included in the reporting period. | number |
| workdaysPerEmployee - Scheduled workdays per employee | The workdays each employee was scheduled to work in the reporting period. | days |
| scheduledWorkdays - Total scheduled workdays | The total available employee workdays before recorded absences. | days |
| daysPresent - Estimated days present | Scheduled workdays remaining after absence days are removed. | days |
Step-by-Step Calculation
Calculate total scheduled workdays
Multiply the number of employees by their scheduled workdays in the reporting period.
scheduledWorkdays = employeeCount * workdaysPerEmployee
Calculate estimated days present
Subtract recorded absence days from scheduled workdays. The maximum function prevents a negative result.
daysPresent = max(0, scheduledWorkdays - absenceDays)
Calculate the absence rate
Divide absence days by scheduled workdays and convert the result to a percentage.
absenceRate = (absenceDays / scheduledWorkdays) * 100
Calculate the attendance rate
Divide estimated days present by scheduled workdays and convert the result to a percentage.
attendanceRate = (daysPresent / scheduledWorkdays) * 100
Check the relationship between rates
When the same scheduled-workday base is used, attendance and absence rates add to 100%.
attendanceRate = 100 - absenceRate
Monthly absence rate calculation for a 25-person team
Find scheduled workdays
25 × 22
550 days
Find estimated days present
550 - 18
532 days
Calculate absence rate
(18 / 550) × 100
3.27%
Calculate attendance rate
(532 / 550) × 100
96.73%
Final Result
The monthly absence rate is 3.3%, and the attendance rate is 96.7%, based on 550 scheduled workdays.
Assumptions
- ✓Each included employee is assumed to have the entered number of scheduled workdays.
- ✓Absence is recorded consistently as full-day or part-day equivalents.
- ✓Scheduled workdays exclude time that is not intended to be worked under the chosen reporting method.
- ✓The employee count reasonably represents the group across the reporting period.
Limitations
- !The calculation is a summary rate and does not show the reasons, duration patterns, or distribution of absences.
- !A changing workforce, varied schedules, or different part-time arrangements can make a single average workday input less precise.
- !Results can differ between groups if they apply different rules for leave, holidays, training, or approved time away.
- !An absence-day total greater than scheduled workdays indicates an input or recording issue rather than a meaningful rate.
Common Mistakes to Avoid
Using calendar days instead of scheduled workdays as the denominator.
Entering annual leave as absence while leaving the same leave days in scheduled workdays without following a consistent policy.
Counting part-day absences as full days instead of converting them to day equivalents.
Comparing a weekly rate with an annual rate without considering seasonal patterns and reporting rules.
Using the closing headcount when the group size changed substantially during the period.
Related Formulas
Frequently Asked Questions
What is the formula for absence rate?
Absence rate equals total absence days divided by total scheduled workdays, multiplied by 100. Total scheduled workdays equal employee count multiplied by scheduled workdays per employee.
How do you calculate attendance rate from absence days?
Subtract absence days from scheduled workdays to find estimated days present. Divide days present by scheduled workdays and multiply by 100.
Do absence rate and attendance rate always add up to 100%?
Yes, in this calculation they add to 100% because attendance is defined as scheduled workdays less recorded absence days.
How are half-day absences included?
Enter them as day equivalents. For example, two half-day absences equal one absence day.
Can the absence rate be above 100%?
It should not be. A result above 100% means absence days exceed scheduled workdays, so the source figures should be checked.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.