Yawmy guide7 min read

Absenteeism Rate Formula: How to Calculate It Monthly

The absenteeism rate formula with a worked 30-employee example, what to count and exclude, the Bradford factor, and how to act on the number each month.

Nada HassanHR-Tech Strategist, YawmyCanonical link

The absenteeism rate formula is simple: divide the working days employees were absent by the working days they were scheduled to work, then multiply by 100. The hard part is not the arithmetic. It is deciding which days belong in the top and the bottom line, and doing it the same way every month so the trend means something. This guide gives the formula, a worked example for a 30-person team, the exclusions that most owners get wrong, and what to do once you have the number. Notes on pay and discipline refer to private-sector employers in Egypt.

TL;DR. Absence rate (%) = absent working days ÷ scheduled working days × 100. Count scheduled days per person after removing rest days and official holidays. Leave approved annual leave out of "unplanned absence" but keep it in its own line. Track the rate monthly and by branch, then look at patterns, not single people. Any deduction or penalty must follow Egypt's Labour Law No. 14 of 2025 and your regulation; this is general information, not legal advice.

This guide is part of our series on employee attendance software in Egypt.

The formula, step by step

Use one version of the formula for the whole company and write it down in your HR notes.

  1. Count scheduled working days. For each employee, list the days they were expected to work in the month. Exclude the weekly rest day and official holidays.
  2. Count absent days. Add the scheduled days on which the employee did not attend. Decide in advance how part-days are handled; many teams count anything under half a shift as a late arrival and anything over as half a day.
  3. Divide and multiply. Total absent days divided by total scheduled days, times 100.

The same maths works for one person, one branch or the whole company. The only change is which employees feed the two totals.

A worked example: 30 employees, one month

A retail company has 30 employees. In the month there are 22 scheduled working days for each person.

Line Calculation Result
Scheduled days 30 employees x 22 days 660
Absent days (all types) Sum from attendance records 33
Absence rate (all types) 33 ÷ 660 x 100 5.0%
Approved annual leave Of the 33, taken as approved leave 14
Unplanned absence 33 minus 14 19
Unplanned absence rate 19 ÷ 660 x 100 2.9%

The all-in 5.0% is useful for staffing. The 2.9% unplanned rate is the one that signals a management problem, because approved leave is a planned cost. The figures are an illustration, not a benchmark. There is no universal "good" rate that applies across industries, so judge yours against its own past months and against the same branch last year.

What to include and what to leave out

Most disagreement about the rate comes from the definition. Settle these points once.

Item In the unplanned rate? Why
Unexcused no-show Yes The clearest case of unplanned absence
Sick day with certificate Yes, shown separately It is unplanned but often justified
Approved annual leave No Planned and approved in advance
Official holiday No Not a scheduled working day
Weekly rest day No Not a scheduled working day
Approved unpaid leave No, own line Planned, but affects payroll
Lateness No, separate metric Time lost, not days lost

Keeping sick leave visible on its own line matters. Folding it into one number tempts managers to treat illness as misconduct. Our guide to tracking overtime and leave shows how to keep the categories apart.

Reading the number: rate by group

One company-wide number hides the problem. Cut it three ways:

  • By branch or team. A branch at 7% while the others sit at 2% is a supervision question, not a hiring one. See how multi-site teams do this in branch attendance for retail.
  • By weekday. Absence clustering on the day after the weekly rest day or before a holiday is a pattern worth a conversation.
  • By shift. Night or early shifts often carry transport problems that a pay change will not fix.

Compare against a three-month average rather than last month alone, since one flu week can distort a small team.

The Bradford factor: when single days matter more

The absence rate treats a five-day absence and five single-day absences the same. They are not the same for an operation that has to cover short-notice gaps. The Bradford factor is a widely used scoring method that weights frequency: score = S x S x D, where S is the number of separate absence spells and D is the total days absent.

Employee Spells (S) Days (D) Score S x S x D
A 1 5 5
B 5 5 125

Employee B's pattern disrupts the schedule far more, and the score shows it. Use the factor as a prompt for a conversation, never as an automatic penalty, and never for absence that stems from a medical condition or protected leave without advice. The score is a tool from HR practice, not a legal test in Egypt.

What a missing day really costs

Convert the rate into pounds so management listens. Take an employee on 6,000 EGP per month. A simple daily rate is 6,000 ÷ 30 = 200 EGP. If the 33 absent days in the example were all paid, the pay for time not worked is 33 x 200 = 6,600 EGP for the month, before counting overtime paid to cover gaps or lost sales. These are illustrative numbers, and your own calculation should use your payroll rules. For hours, see how to calculate working hours.

From number to action

  1. Fix the record first. A rate built on guessed attendance is worse than none. Use clock-in records, not memory.
  2. Talk before you penalise. A return-to-work conversation after each unplanned absence clears up more than a warning letter.
  3. Check the procedure. Deductions and penalties need a written regulation and a hearing under the Labour Law. Read the attendance policy guide and confirm your wording with a lawyer.
  4. Review monthly. Put the rate, the unplanned rate and the worst branch on one slide for management.

How Yawmy fits

Yawmy records check-in and check-out and produces attendance reports, so scheduled and attended days come from one record instead of a hand-built sheet. The free plan covers 2 employees; Pro is 500 EGP per month or 4,500 EGP per year with unlimited employees. See the current details on the Yawmy site.

FAQ

What is a normal absenteeism rate?

There is no single normal figure, because it varies by industry, shift pattern and season. Treat your own history as the baseline and watch the direction of the trend. Do not borrow a benchmark you cannot source.

Should public holidays count in the formula?

No. Official holidays and the weekly rest day are not scheduled working days, so they come out of both the top and the bottom of the fraction. Including them makes the rate look lower than it is.

Is lateness part of the absenteeism rate?

Keep it separate. Lateness measures minutes or hours lost, while absence measures whole days lost. Mixing them hides which problem you actually have.

How often should I calculate the rate?

Monthly is enough for most companies, with a rolling three-month average beside it. Weekly figures swing too much for teams under fifty people.

Can I deduct pay for absence in Egypt?

Pay for unworked days and disciplinary deductions are different things, and each has rules under the Labour Law and your regulation. Get the clause checked by a labour lawyer before you apply it. This article does not give legal advice.

Written by Nada Hassan, HR-Tech Strategist at Yawmy. This is general information, not legal advice.

To get absence counted from live check-in records instead of a hand-built sheet, open Yawmy or visit the Yawmy home page.

Want absence numbers without rebuilding a spreadsheet each month?

Tell us your team size and branches; your request goes straight to the Yawmy team.

Your details go to the sales team only.
Start here

Turn attendance and payroll into a clean system in minutes.

Try Yawmy for free, add your team, and connect Telegram check-ins, GPS proof, and payroll-ready reports without Excel or WhatsApp chaos.

Yawmy
GPS attendance
Payroll reports
Teams & branches
No hardware