Absenteeism Rate Formula: How to Calculate Employee Absence Rate

Absenteeism rate measures the share of scheduled work time lost to absence during a defined period. It can help HR teams and managers track attendance patterns consistently across teams or reporting periods.

A straightforward workday-based formula is:

Absence rate = (Absent workdays ÷ Scheduled workdays) × 100

For example, if a team had 25 absent workdays out of 1,000 scheduled workdays, the absence rate was 2.5%.

Use the Absence Rate Calculator to calculate the percentage from absent and scheduled workdays.

Absenteeism rate formula

The calculation needs two values measured over the same population and period:

• Absent workdays: workdays lost to the absence types included in your reporting definition.
• Scheduled workdays: the total workdays that the same employees were scheduled to work during the period.

Formula:

(Absent workdays ÷ Scheduled workdays) × 100

The denominator is important. If the employee population or reporting period changes between the numerator and denominator, the result can become misleading.

Worked example

Suppose a department has 20 employees and, for the month being measured, there are 440 scheduled employee-workdays in total. Employees miss 11 of those workdays under the organization’s absence definition.

11 ÷ 440 × 100 = 2.5%

The department’s absence rate is 2.5% for that month.

This does not automatically tell you whether the rate is good or bad. Interpretation depends on the organization’s history, workforce type, seasonality, policy, and what kinds of absence are included.

How to calculate scheduled workdays

The denominator should reflect the total scheduled work opportunity for the population being measured.

For a simple Monday-to-Friday schedule, you can start with the number of weekdays in the reporting period and multiply by the number of employees, adjusting for each person’s actual schedule where needed.

For example:

• 22 scheduled weekdays in the month
• 20 employees with the same full-time schedule

22 × 20 = 440 scheduled employee-workdays

The Working Days Calculator can help count Monday-to-Friday weekdays between dates. It does not automatically apply public holidays, custom workweeks, or employee-specific schedules, so adjust the denominator to match your real reporting rules.

What absences should be included?

There is no single universal reporting definition that fits every organization. Before comparing absence rates, document which absence types count.

Depending on the purpose of the metric, an organization may choose to include or exclude categories such as:

• unscheduled sick days;
• unplanned personal leave;
• no-shows;
• approved medical leave;
• vacation or PTO;
• parental leave;
• training or business travel.

The key analytical rule is consistency. If approved vacation is excluded this quarter but included next quarter, the rates are not directly comparable.

Planned vs unplanned absence

A useful refinement is to separate planned from unplanned absence.

Planned absence may include approved vacation or scheduled leave known in advance.

Unplanned absence may include unexpected illness, no-shows, or other unscheduled time away, depending on policy.

Tracking these categories separately can make the metric more actionable. A high planned-leave rate may reflect seasonality or policy use, while a rise in unplanned absence may signal a different operational issue.

Absence rate vs attendance rate

Absence rate and attendance rate are related but not always exact complements unless the definitions use the same scheduled-time denominator and mutually exclusive categories.

In a simple model where every scheduled day is either attended or absent:

Attendance rate = 100% − Absence rate

If the absence rate is 3%, attendance would be 97% under that simplified definition.

Real workforce reporting may include partial days, leave categories, remote work, holidays, or other statuses, so confirm how each metric is defined before treating them as exact opposites.

Absence rate vs employee turnover rate

Absence rate measures lost scheduled work time. Employee turnover rate measures employees leaving the organization relative to headcount.

A team can have low turnover but high absence, or high turnover but low absence. They answer different questions.

Use the Employee Turnover Calculator when you want to measure departures relative to average headcount.

Monthly absence rate example

Assume a small organization has 1,100 scheduled employee-workdays in a month and records 33 absent workdays.

33 ÷ 1,100 × 100 = 3%

The monthly absence rate is 3%.

If the next month has 28 absences out of 1,120 scheduled workdays:

28 ÷ 1,120 × 100 = 2.5%

The rate improved from 3% to 2.5%, but it is better to review several periods before concluding that a durable trend exists.

How to interpret absence-rate trends

A single percentage rarely explains the cause of absenteeism. Use the metric as a starting signal, then segment the data where appropriate.

Useful views can include:

• month-over-month trend;
• team or location;
• planned vs unplanned absence;
• full-time vs part-time schedules;
• absence reason categories where appropriate and permitted;
• seasonal patterns;
• recurring weekday patterns.

Be careful with very small teams. One absence can move the percentage sharply when the denominator is small.

Common absenteeism-rate mistakes

Mixing employees or periods

The absent-workday numerator and scheduled-workday denominator must cover the same employees and the same time period.

Using calendar days instead of scheduled workdays

Weekends and non-working days should not automatically enter the denominator unless they are genuinely scheduled workdays for that workforce.

Changing the absence definition over time

Trend comparisons become unreliable when included categories change without restating prior periods.

Ignoring partial-day absences

If partial days matter, convert both absence and scheduled time to a consistent unit such as hours rather than rounding everything to full days.

Treating the rate as a diagnosis

The metric shows frequency or volume of lost scheduled time, not the reason. Avoid drawing conclusions about employee behavior or management causes from the percentage alone.

Day-based vs hour-based absence rate

If employees work different shift lengths, hours can provide a more precise denominator.

The hour-based version is:

Absence rate = (Absent hours ÷ Scheduled hours) × 100

For example, 40 absent hours out of 2,000 scheduled hours equals 2%.

Use either days or hours consistently. Do not divide absent hours by scheduled days or combine incompatible units.

FAQ

What is the absenteeism rate formula?

A common formula is (absent workdays ÷ scheduled workdays) × 100. Organizations may also use an hour-based version when shift lengths vary.

Should PTO count as absenteeism?

That depends on the reporting purpose and policy. Some organizations exclude approved vacation from absenteeism reporting while others track all time away in broader absence metrics. Define the rule before comparing results.

Can I compare absence rates across companies?

Only cautiously. Differences in workforce type, schedules, leave policies, geography, seasonality, and reporting definitions can make cross-company comparisons unreliable.

How often should absence rate be calculated?

Monthly reporting is common for operational trend tracking, while quarterly or annual views can help smooth short-term volatility. Use a cadence that matches the decision being made.

Calculate your employee absence rate

Enter absent workdays and scheduled workdays in the Absence Rate Calculator to calculate the percentage, then document the reporting definition so future comparisons remain consistent.