Absence Percentage Calculator
Enter the total days absent, the number of employees and the workdays per employee to find the absence percentage.
Updated
Absence Percentage Calculator
Our Absence Percentage Calculator finds the share of available workdays that employees missed in a period, also called the absenteeism rate or absence rate. Enter the total days absent, the number of employees and the workdays per employee to get the absence percentage, the attendance rate and the days worked in seconds.
Quick answer
Absence percentage is days absent ÷ (employees × workdays) × 100: 50 ÷ (100 × 20) × 100 = 2.5%.
- Available workdays: employees × workdays per employee (100 × 20 = 2,000)
- Attendance rate: 100% − absence % (100% − 2.5% = 97.5%)
- Same period: count absences and workdays over the same dates
- Days absent cannot be more than the available workdays
What Is Absence Percentage?
Absence percentage measures how much scheduled work time a team missed compared with the total workdays available in a period. It is one of the most common HR metrics, used to track attendance, spot patterns and plan cover. A team of 250 people with 22 workdays each has 5,500 available workdays. If they missed 37 days in total:
It works for any period (a week, a month, a quarter or a year) as long as the absences and the workdays cover the same dates.
How to Calculate Absence Percentage
÷ (employees × workdays)
× 100
- Find the available workdays. Multiply employees by workdays per employee: 100 × 20 = 2,000.
- Divide the days absent by that total. 50 ÷ 2,000 = 0.025.
- Multiply by 100. 0.025 × 100 = 2.5%.
For one person, enter 1 as the number of employees. The same formula also works with hours instead of days, as long as both numbers use the same unit.
Absence Percentage Examples
| Absent ÷ (employees × days) | Absence |
|---|---|
| 12 ÷ (250 × 2) | 2.4% |
| 50 ÷ (100 × 20) | 2.5% |
| 150 ÷ (500 × 10) | 3% |
| 1,056 ÷ (1,200 × 22) | 4% |
| 9 ÷ (1 × 180) | 5% |
Absence Rate and Attendance Rate
The attendance rate is the other side of the same number. Subtract the absence percentage from 100%:
= 97.5%
The calculator shows both, together with the days actually worked (2,000 − 50 = 1,950) and the average days absent per employee (50 ÷ 100 = 0.5).
What Is a Good Absence Rate?
There is no single target, because it depends on the industry, the kind of work and what counts as an absence. Many employers see overall rates of roughly 2% to 4% of working time. A useful check is to compare your rate with your own past periods and with similar teams, and to look into sudden rises or one team that is well above the rest.
Why Absence Percentage Matters
High absenteeism can point to low morale, health problems, poor working conditions or management issues. Tracking absence percentage regularly helps you:
- Spot patterns, such as a rise in one team or one season
- Plan cover and staffing more accurately
- Check whether wellbeing or attendance policies are working
- Prepare clear, consistent HR reports
Common Mistakes
- Counting non-working days. Leave weekends and public holidays out of the workdays.
- Mixing planned and unplanned leave. Most absence rates count sickness and unplanned absence only, not booked holiday.
- Mismatched periods. Absences for a quarter against workdays for a month give a wrong answer.
- Ignoring part-time staff. Use the days each person was scheduled to work, or total scheduled days with 1 employee.
Key Terms
- Days absent
- Total scheduled days missed by everyone.
- Workdays
- Scheduled days per employee in the period.
- Available
- Employees × workdays.
- Attendance
- 100% minus the absence percentage.
How to Use the Absence Percentage Calculator
- Enter the total days absent. Type the days missed by everyone in the period, such as 50. Half days such as 2.5 work.
- Enter the employees and workdays. Type the number of employees, such as 100, and the workdays per employee in the same period, such as 20.
- Read and copy the result. The absence percentage appears as you type, with a bar, the working, the available workdays, the days worked, the attendance rate and the average days absent per employee. Press Copy to copy it, or Clear or Esc to start again.
Example: a team of 100 had 50 days of absence in a month with 20 workdays. Enter 50, 100 and 20. The result is 2.5%, with an attendance rate of 97.5% and 1,950 days worked.
Who Can Use This Calculator?
Frequently Asked Questions (FAQs)
How do you calculate absence percentage?
Multiply the employees by the workdays per employee, divide the total days absent by that number, then multiply by 100. 50 ÷ (100 × 20) × 100 = 2.5%.
What is the formula for absenteeism rate?
Absenteeism rate = days absent ÷ (employees × workdays in the period) × 100. It is the same as the absence percentage.
What is a good absence percentage?
It depends on the industry and on what counts as an absence, but many employers see rates of roughly 2% to 4%. Compare your rate with your own past periods and with similar teams.
How do I work out the attendance rate?
Subtract the absence percentage from 100%. An absence rate of 2.5% means an attendance rate of 97.5%.
Should holidays count as absence?
Usually not. Booked holiday and public holidays are left out of the workdays, and the absence rate counts sickness and other unplanned absence.
How do I include part-time employees?
Use the days each person was scheduled to work. Add them up, enter that total as the workdays and enter 1 as the number of employees.
Can I use hours instead of days?
Yes. Enter hours absent and scheduled hours per employee. The percentage is the same as long as both use the same unit.
What is 9 days absent out of 180 school days as a percentage?
9 ÷ 180 × 100 = 5% absence, which is a 95% attendance rate. Enter 9, 1 and 180.
Is the Absence Percentage Calculator free?
Yes. It is completely free, needs no sign-up, and can be used as many times as you like.
Sources
- CIPD. Health and wellbeing at work (UK absence levels and absence management survey).
- U.S. Bureau of Labor Statistics. Absences from work of employed full-time wage and salary workers (hours absent as a percent of hours usually worked).
Try our Absence Percentage Calculator to see your team absence rate, attendance rate and days worked in seconds.