Absenteeism Rate Calculator Formula
Understand the math behind the absenteeism rate calculator. Each variable explained with a worked example.
Formulas Used
Absenteeism Rate
absenteeism_rate = (total_employees * workdays_in_period) > 0 ? (absent_days / (total_employees * workdays_in_period)) * 100 : 0Total Available Workdays
total_available_days = total_employees * workdays_in_periodAvg Absent Days Per Employee
avg_absent_per_employee = total_employees > 0 ? absent_days / total_employees : 0Variables
| Variable | Description | Default |
|---|---|---|
absent_days | Total Absent Days (unplanned) | 45 |
total_employees | Number of Employees | 50 |
workdays_in_period | Workdays in Period | 22 |
How It Works
How to Calculate Absenteeism Rate
Formula
Absenteeism Rate = (Absent Days / Total Available Workdays) x 100 Total Available Workdays = Number of Employees x Workdays in Period
Absenteeism rate counts only unplanned absences (sick days, no-shows, personal emergencies), not scheduled PTO or holidays. Chronic absenteeism inflates costs through overtime, temporary staffing, and lost productivity. Tracking the rate by department or team helps identify localized issues like burnout or poor management.
Worked Example
50 employees accumulated 45 unplanned absence days in a month with 22 workdays.
absent_days = 45total_employees = 50workdays_in_period = 22
- 01Total Available Workdays = 50 x 22 = 1,100
- 02Absenteeism Rate = (45 / 1,100) x 100 = 4.09%
- 03Avg Absent Days Per Employee = 45 / 50 = 0.9 days
Ready to run the numbers?
Open Absenteeism Rate Calculator