Team Absence Rate Formula
Learn how to calculate a team's absence rate, scheduled days worked, and attendance rate for one reporting period.
A team absence rate shows the share of scheduled working days that were lost to recorded absence. Using the same period and inclusion rules each time makes this percentage more useful for tracking changes over time.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Team absence rate
Where:
First find all days the team was scheduled to work. Then divide recorded absence days by that total and convert the result to a percentage.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| totalAbsentDays - Total absence days | The combined qualifying absence days recorded across the team in the reporting period. | days |
| teamSize - Number of team members | The average number of employees in the team during the reporting period. | number |
| workingDaysPerEmployee - Scheduled working days per employee | The scheduled workdays for each employee in the reporting period. | days |
| totalScheduledDays - Total scheduled team days | The total number of scheduled days available across the team. | days |
| daysWorked - Scheduled days worked | Scheduled team days remaining after absence days are deducted. | days |
| attendanceRate - Team attendance rate | The percentage of scheduled team days not recorded as absence. | percent |
Step-by-Step Calculation
Set a single reporting period
Use matching dates for team size, scheduled workdays, and absence days, such as one calendar month or quarter.
reportingPeriod = same period for all inputs
Calculate scheduled team days
Multiply the average team size by the scheduled days per employee.
totalScheduledDays = teamSize * workingDaysPerEmployee
Calculate the absence rate
Divide total absence days by scheduled team days and multiply by 100.
absenceRate = (totalAbsentDays / totalScheduledDays) * 100
Calculate scheduled days worked
Subtract recorded absence days from the scheduled team total.
daysWorked = totalScheduledDays - totalAbsentDays
Calculate the attendance rate
Divide scheduled days worked by total scheduled days and convert to a percentage.
attendanceRate = (daysWorked / totalScheduledDays) * 100
Monthly absence rate for a 10-person team
Calculate total scheduled team days
10 × 22
220 days
Calculate absence proportion
8 ÷ 220
0.03636
Convert to absence rate
0.03636 × 100
3.64%
Calculate scheduled days worked
220 - 8
212 days
Calculate attendance rate
212 ÷ 220 × 100
96.36%
Final Result
The estimated team absence rate is 3.64%. The team had 212 scheduled days worked and a 96.36% attendance rate.
Assumptions
- ✓All inputs relate to the same reporting period.
- ✓Each team member is represented by the same scheduled-days figure.
- ✓Total absence days are counted using one consistent organisational definition.
- ✓Absence days do not exceed total scheduled team days.
Limitations
- !The result is a high-level team metric and does not show how absence is distributed among individuals.
- !A single average schedule may be less accurate for teams with varied part-time, shift, or start and end dates.
- !The calculation does not assess causes, frequency, operational impact, or employee wellbeing.
- !Different organisations may include different absence categories, limiting comparisons across organisations.
Common Mistakes to Avoid
Using calendar days rather than scheduled working days in the denominator.
Combining absence days from one period with scheduled days from another.
Including annual leave without also applying the same treatment consistently to scheduled days.
Using the end-of-period headcount when team size changed substantially during the period.
Counting a partial-day absence as a whole day when records use half days or hours.
Entering more absence days than the team was scheduled to work.
Related Formulas
Frequently Asked Questions
What is the formula for team absence rate?
Team absence rate = total absence days ÷ total scheduled team days × 100. Total scheduled team days are team size × scheduled working days per employee.
How do I calculate attendance rate from absence rate?
When the same scheduled-day basis is used, attendance rate = 100 - absence rate. It can also be calculated as scheduled days worked ÷ total scheduled days × 100.
Why multiply team size by working days?
This creates the total scheduled working-day capacity for the team, which is the denominator needed to express absence as a percentage.
Can the absence rate be over 100%?
It should not be under a consistent day-based method. A result above 100% usually indicates mismatched reporting periods, duplicated records, or absence days greater than scheduled days.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.