How to Calculate Employee Attendance Rate

Attendance rate sounds like it should be obvious, but the moment you try to put a number on it, questions pile up. Does a half-day count? What about approved vacation? The math itself is simple once you settle those questions; it’s really just a ratio of days present to days scheduled.

What attendance rate measures

Attendance rate is the share of scheduled working days that an employee actually showed up for, expressed as a percentage. It’s a period metric, meaning you calculate it over a defined stretch of time (a month, a quarter, a review cycle), not for a single day. You need two inputs: how many days the employee was present, and how many working days were scheduled in that period.

“Scheduled working days” matters more than it looks. It should reflect the days the employee was actually expected to work, so weekends and company holidays are usually excluded from the total, since nobody was scheduled to be there anyway. If you include non-working days in the denominator, you’ll understate the rate and make attendance look worse than it is.

Once you have those two numbers, attendance rate and its mirror image, absence rate, always add up to 100%. If someone attended 90% of scheduled days, they were absent for the other 10%, by definition.

The formula

Attendance Rate (%) = (Days Present / Total Working Days) x 100
Days Absent         = Total Working Days - Days Present
Absence Rate (%)    = 100 - Attendance Rate

Days present and total working days are both counts of days, not hours, so this calculation doesn’t care whether someone worked a full 8-hour shift or left two hours early; it treats the day as either present or not. If you need to weight partial days differently, you’ll need to adjust your day-present count before you plug it into the formula, since the ratio itself has no concept of partial credit.

Worked examples

Say an employee was present for 22 out of 24 scheduled working days in a month:

• Attendance rate: 22 / 24 x 100 = 91.67%
• Days absent: 24 - 22 = 2 days
• Absence rate: 100 - 91.67 = 8.33%

Now take a shorter, four-week stretch where the same employee was present for 18 out of 20 scheduled working days:

• Attendance rate: 18 / 20 x 100 = 90.00%
• Days absent: 20 - 18 = 2 days
• Absence rate: 100 - 90.00 = 10.00%

Notice that the same 2 missed days produced two different rates (91.67% versus 90.00%) because the denominator changed. That’s the part people get wrong most often when comparing attendance across employees or teams: two missed days out of a 24-day month is a materially better rate than two missed days out of a 20-day month, even though the raw absence count looks identical. Always compare rates, not raw day counts, when the scheduling periods aren’t the same length.

What counts as a day present

The formula is easy; the judgment call is upstream of it, in deciding what goes into “days present.” A few common sticking points:

Paid time off is the biggest one. If you’re measuring strict physical attendance, an approved vacation day isn’t a day present, and it should reduce the rate the same way an unplanned absence would. Plenty of employers do the opposite instead: they count approved PTO, sick leave, and other pre-scheduled time off as present, and only let unplanned, unapproved absences pull the rate down. Neither approach is wrong, but you have to pick one convention and apply it consistently, or your numbers won’t mean the same thing from month to month or from one employee’s record to another’s.

Partial days are the second sticking point. If someone shows up two hours late or leaves early, some companies count that as a full present day (they showed up, after all), while others count it as a fraction or dock it entirely. Decide this before you run the numbers, not after, so you’re not tempted to round in whichever direction makes a given month look better.

As for what counts as a good rate, there’s no single industry standard, but many employers start asking questions once attendance drops below roughly 90 to 95%. A rate in that range, sustained over a few months, is usually worth investigating, whether the underlying cause is a scheduling problem, an accommodation your PTO policy isn’t covering well, or an individual issue that needs a direct conversation. A single bad month is normal; a persistent trend below that band is the signal worth acting on.

FAQ

Does attendance rate include scheduled vacation and holidays? Holidays and days the employee wasn’t scheduled to work shouldn’t be in the total working days count at all, since they were never a chance to be absent. Scheduled vacation is different: whether it counts as present or reduces the rate depends on your company’s convention, so pick one and use it consistently across employees and periods.

How is attendance rate different from absence rate? They’re two views of the same number. Attendance rate is the percentage of scheduled days worked; absence rate is the percentage missed. Add them together for any given period and you should always get 100%, so if your numbers don’t add up, double-check the total working days figure first.

What’s a good attendance rate to aim for? There’s no universal threshold, but many employers treat sustained rates below roughly 90 to 95% as a signal to look closer, whether that means reviewing PTO policy, checking for a workplace issue, or addressing an individual pattern directly. A single low month usually isn’t cause for concern on its own.

Use the Attendance Calculator to run your own numbers.