Absence Percentage Calculator
Use our absence percentage calculator to calculate absenteeism rate from total employees, total workdays, and total days absent. Includes the absent percentage formula, how to calculate absence rate, and an Excel-style monthly absenteeism percentage method.
What Is Absence Percentage?
Absence percentage (often called absenteeism rate) is a workforce metric that shows how much scheduled work time was missed due to absences over a given period.
It’s typically calculated using the total number of days absent divided by the total number of available workdays for all employees in that period.
This metric is useful for HR and operations because it helps track attendance trends over time (weekly, monthly, or quarterly) and compare teams or locations.
Absence Percentage Formula
To calculate absence percentage, divide total days absent by total available workdays (employees × workdays), then multiply by 100.
Workdays means scheduled workdays per employee in the period.
This is the standard absent percentage formula used for attendance reporting.
Interpretation: 3.6% of scheduled workdays were missed.
If it does, at least one input is wrong for the period chosen.
How to Calculate Absenteeism Percentage
- 1
Enter total employees for the period.
- 2
Enter total workdays per employee in the period (for example, 20 workdays in a typical month).
- 3
Enter total days absent across all employees in the same period.
- 4
The calculator returns your absenteeism rate: (days absent ÷ (employees × workdays)) × 100.
Frequently Asked Questions
Absence % = (Days absent ÷ (Employees × Workdays)) × 100.
Compute the total available workdays (employees × workdays), then divide total days absent by that number and multiply by 100.
They’re commonly used interchangeably in workplace metrics. Both typically refer to the same calculation: days absent divided by total scheduled workdays.
If Employees is in A1, Workdays is in B1, and DaysAbsent is in C1, use: = (C1/(A1*B1))*100. Format the cell as a percentage if you prefer.
Use whatever your organization defines as absence (for example, unscheduled absences, sick days, unexcused days). Just keep the definition consistent across months so the trend is meaningful.