Absence Percentage Calculator
Work out an employee, team, or organisation absence rate as a percentage of scheduled working days. Uses the standard CIPD / SHRM absence-rate formula.
Absence percentage
2%
- Attendance percentage
- 98%
- Days present
- 245
- Days absent (used)
- 5
- Scheduled working days
- 250
Over 250 scheduled working days, 5 days of absence gives an absence rate of 2.00% and an attendance rate of 98.00%.
How to use this calculator
Enter the number of days the employee (or team) was absent during the period, and the total number of scheduled working days in the same period. The calculator returns the absence rate as a percentage, the corresponding attendance rate, and a breakdown of days present versus days absent. You can enter half-days as 0.5. If you are computing a team-level rate, add all team members' absent days and multiply the working days by the number of team members before entering.
How the calculation works
The calculator applies the standard workforce absence formula used by the Chartered Institute of Personnel and Development (CIPD) in the UK and the Society for Human Resource Management (SHRM) in the US: absence rate = (days absent ÷ scheduled working days) × 100. Attendance rate is the complement: 100% − absence rate. If the days absent entered exceeds the scheduled working days (usually an input mistake), the calculator caps the result at 100% so the output stays meaningful. The formula treats every scheduled working day equally — a half day off counts as 0.5, a full day counts as 1, and non-working days such as weekends or bank holidays are not counted because they are not part of the scheduled working days.
Worked example
Suppose a full-time employee was rostered to work 250 days over the year (52 weeks × 5 days − 10 bank holidays). Over the year they took 5 sick days and 2 half-days for medical appointments, giving 6 absence-days in total. The absence rate is (6 ÷ 250) × 100 = 2.40%, and the attendance rate is 100% − 2.40% = 97.60%. This is comfortably below the UK all-industry median absence rate of ~3.8% reported by CIPD Health & Wellbeing at Work.
Frequently asked questions
What is the absence percentage formula?
Absence percentage = (days absent ÷ scheduled working days) × 100. This is the formula published by the CIPD (Chartered Institute of Personnel and Development) and by SHRM (Society for Human Resource Management), and is the same one used by most HR information systems. It measures unplanned absence as a share of time the person was expected to be at work — so annual leave, weekends, and public holidays are excluded from the denominator because they are not scheduled working days in the first place.
Should I include annual leave, bank holidays, or weekends in "days absent"?
No. The absence-rate metric measures unscheduled absence — sickness, unauthorised leave, and other short-notice time away from rostered work. Booked annual leave, public/bank holidays, and non-working days are not absences because the employee was not expected to be at work. Similarly, exclude parental leave, sabbaticals, and other long-term planned absences unless your HR policy explicitly counts them. If you include them, make sure the working-days figure is also adjusted so the comparison stays fair.
What counts as a "good" absence rate?
CIPD's Health & Wellbeing at Work survey has historically found UK all-employer averages of around 3.5% to 4.0% (~7.8 days per employee per year). Public sector employers typically run 1–2 percentage points higher than private sector. In the US, the Bureau of Labor Statistics reports an absence rate of around 3.0% for full-time wage and salary workers. A rate under 2% is generally considered excellent; anything above 5% usually triggers HR intervention. Context matters — a call centre, a hospital ward, and a software firm all sit in different ranges.
How do I handle half-days or hourly absences?
For half-days, enter 0.5 in the days-absent field — the calculator accepts fractional inputs. For hourly absences (someone left two hours early), divide the hours by the standard working day length: 2 hours out of an 8-hour day is 0.25 days. If you track absence entirely in hours, you can also apply the formula as (hours absent ÷ scheduled working hours) × 100, which gives the same percentage; just enter both figures in the same unit.
How is this different from the Bradford Factor?
Absence percentage measures the amount of absence relative to expected time at work. The Bradford Factor is a different metric that weights frequency of absence episodes more heavily than total duration, calculated as S² × D, where S is the number of separate absence spells and D is the total days absent. A person with one 20-day absence gets Bradford = 1² × 20 = 20; ten one-day absences give 10² × 10 = 1,000. Use absence percentage to report headline absence load, and the Bradford Factor to flag disruptive patterns of short, frequent absences.
How should team or department absence be calculated?
Sum every team member's absent days for the period, and multiply the scheduled working days per person by the headcount. For example, a team of 10 people each rostered for 220 working days over the period has a denominator of 2,200 working days. If total absence across the team was 66 days, the team absence rate is (66 ÷ 2,200) × 100 = 3.0%. For fluctuating headcount, use the average headcount over the period, or better still, a weighted "full-time-equivalent working days" total.