Attendance Rate Calculator
Attendance rate = days present ÷ scheduled days × 100. 114 days present out of 120 is 95%. Calculate it for one person or a team and see how many perfect days it takes to reach your target.
- Attendance % = days present ÷ scheduled days × 100.
- Attendance rate + absence rate = 100%.
- 95% attendance = about 1 day missed per month on a 20-day month.
- Count only scheduled days in the denominator.
How to calculate attendance percentage
- Count scheduled daysOnly days the person was expected to attend — exclude holidays, approved leave and non-working days.
- Count days presentDays attended; decide how to treat half days (0.5 is common).
- Divide and multiply by 100110 ÷ 120 × 100 = 91.7%.
For a team: attendance = (people × scheduled days − total absent days) ÷ (people × scheduled days) × 100. 30 people × 20 days = 600; minus 24 absent days = 576; 576 ÷ 600 = 96%.
How to use the Attendance Rate calculator
Fill in the fields above and press Calculate. Results appear straight away, in your browser — nothing is sent or stored.
- Calculate for — choose from: One person, A team or class.
- Days present — starts at 110; replace it with your own figure. (shown when relevant)
- Scheduled days — starts at 120; replace it with your own figure. (shown when relevant)
- People — starts at 30; replace it with your own figure. (shown when relevant)
- Scheduled days in the period — starts at 20; replace it with your own figure. (shown when relevant)
- Total days absent — starts at 24; replace it with your own figure. (shown when relevant)
- Target attendance — starts at 95; replace it with your own figure.
Change any value and press Calculate again to compare scenarios. All figures are estimates for planning; check them against your own policy, contract and local rules before using them for payroll.
How many perfect days to reach a target?
If attendance is below target, each fully attended day raises it a little. The number of consecutive perfect days needed = (target × scheduled − present) ÷ (1 − target). At 110 of 120 days (91.7%), reaching 95% needs (0.95 × 120 − 110) ÷ 0.05 = 80 more perfect days. The calculator shows this automatically — and it shows why early absences are hard to recover from.
Attendance quick answers
What is the attendance rate for 19 of 20 days?
95%.
What is the attendance rate for 18 of 20 days?
90%.
What is the attendance rate for 170 of 180 school days?
94.4%.
What is the attendance rate for 225 of 240 days?
93.75%.
What is the attendance rate for a class of 25 over 20 days with 30 absences?
94% (470 ÷ 500).
What is the attendance rate for missing 2 days a month?
about 90% on a 20-day month.
What attendance rate is good?
- Workplaces: 95% or higher is a common target; it allows roughly one unplanned absence a month.
- Schools: many US education agencies treat missing 10% or more of school days (below 90% attendance) as chronic absenteeism.
- Shift work: attendance targets often sit alongside punctuality targets measured with the tardiness calculator.
Set targets that leave room for genuine illness, and look at patterns before individual numbers.
Worked examples
Real-world scenarios, worked through step by step.
Employee review
232 of 245 scheduled days = 94.7%.
Team monthly report
18 people × 21 days = 378 scheduled; 11 absent days → 97.1%.
Recovering to target
45 of 50 days (90%) → reaching 95% needs 50 more perfect days.
Half days
2 half-day absences count as 1 day: 99 of 100 days = 99%.
Attendance tracking methods
Accurate attendance depends on recording it daily. Paper sign-in sheets are easy to fill in later; digital clock-in on phone or computer records the real time, and GPS clock-in verifies field staff arrived on site. See digital attendance systems for growing teams and the practical guide to tracking attendance.
Improving attendance
- Make expectations clear: what counts as an absence and how to report it.
- Talk to people after absences — supportive, not punitive.
- Look for causes: workload, schedules, commute, caring responsibilities.
- Recognize good attendance without penalizing genuine illness.
- Review team attendance monthly alongside the absenteeism rate calculator.
An attendance policy that works
A clear, fair attendance policy prevents most disputes. A practical policy covers:
- Scope: who it applies to and which absences it covers (unplanned absence, not approved leave or legally protected leave).
- Reporting: how and when to report an absence — e.g. call or message your manager at least an hour before the shift.
- Records: how attendance is recorded (clock-in, timesheet) and who can see the records.
- Thresholds: the attendance level that triggers a conversation, e.g. below 95% over a rolling 3 months.
- Support first: return-to-work conversations, occupational health, flexible arrangements.
- Formal steps: progressive stages, applied consistently.
- Review: how often the policy and the numbers are reviewed.
Excluding protected leave matters: in the US, absences covered by laws such as the FMLA, the ADA or state sick-leave laws must not count against employees.
Attendance for shift and remote teams
- Shift teams: attendance is measured against the rota. Late swaps and no-shows should be visible to supervisors in real time so cover can be arranged.
- Field teams: mobile clock-in with location verification confirms arrival at the job site rather than at the depot — see what GPS tracking is allowed.
- Remote teams: “attendance” means being available in agreed working hours. Clock-in or a timer start is the equivalent of arriving at the office.
- Hybrid teams: decide whether office days are an attendance requirement and record them consistently.
What to include in a monthly attendance report
| Metric | Why it matters |
|---|---|
| Attendance rate by team | Spot teams under pressure |
| Unplanned absence days | Separate from approved leave |
| Absence spells (frequency) | Frequent short absences need a different response than one long absence |
| Late arrivals | Punctuality trends, from the tardiness report |
| Trend vs last 3 months | Direction matters more than one month |
How different industries use it
- healthcare: Unfilled shifts affect patient safety; attendance is monitored by ward and rota, with agency cover as the expensive fallback.
- call centers and bpos: Attendance directly affects service levels; absent agents mean longer queues and overtime for others.
- construction and field service: Crew attendance at the job site, verified at clock-in, decides whether a job starts on time.
- ecommerce and retail: Peak-season attendance drives fulfilment speed; temporary staff need the same tracking as permanent staff.
- Schools and training: Attendance below 90% is a common warning threshold for students and apprentices.
Attendance targets in days
What common attendance targets mean in days missed:
| Attendance target | Days missed per 20-day month | Days missed per 245-day year |
|---|---|---|
| 99% | 0.2 | 2.5 |
| 98% | 0.4 | 4.9 |
| 97% | 0.6 | 7.3 |
| 96% | 0.8 | 9.8 |
| 95% | 1.0 | 12.2 |
| 93% | 1.4 | 17.1 |
| 90% | 2.0 | 24.5 |
The difference between 95% and 97% sounds small but is about 5 days a year per person. For a team of 20, that is 100 days of cover.
Do it in Excel or Google Sheets
Days present B1, scheduled days B2, target B3 (e.g. 95%).
- Attendance rate
=B1/B2 - Absence rate
=1-B1/B2 - Perfect days needed to reach target
=MAX(0,ROUNDUP((B3*B2-B1)/(1-B3),0))
Format rate cells as percentages.
Who uses the Attendance Rate calculator — and why
- Managers reviewing team attendance.
- HR running attendance reports.
- Schools and trainers tracking students.
- Shift supervisors.
- Employees checking their own record.
- Apprenticeship and course providers with attendance requirements.
How we calculate
- Attendance rate = days present ÷ scheduled days × 100.
- Days needed to reach a target = (target × scheduled − present) ÷ (1 − target), rounded up.
- All calculations run in your browser; nothing you type is sent to StaffTiming or stored.
Formulas checked against the sources above. Last reviewed: October 2026. This tool gives estimates for planning, not legal, tax or payroll advice.
Key terms explained
- Attendance rate
- Days present ÷ days scheduled.
- Scheduled day
- A day the person was expected to attend.
- Chronic absenteeism
- In schools, often defined as missing 10% or more of days.
- Perfect attendance
- 100% of scheduled days attended.
- Half-day absence
- Usually counted as 0.5 days.
- Attendance policy
- Written rules on reporting and managing absence.
- Punctuality
- Arriving on time; measured separately from attendance.
- Absence rate
- 100% minus the attendance rate.
Frequently asked questions
How do I calculate attendance percentage?
Divide days present by scheduled days and multiply by 100.
What is a good attendance rate at work?
Many employers aim for 95% or higher.
Is 90% attendance good?
It means missing about 2 days a month; many workplaces and schools would see it as low.
Do holidays count in attendance?
No — only scheduled days count.
How are half days counted?
Usually as 0.5 days present.
How do I calculate team attendance?
Total days present ÷ total scheduled days for everyone.
What is chronic absenteeism?
In US schools it is commonly defined as missing 10% or more of school days.
How many days can I miss for 95%?
1 day in 20, or about 12 days in a 245-day work year.
How do I improve attendance?
Clear expectations, supportive conversations and fixing root causes.
Should lateness count as absence?
Track it separately as tardiness.
Is attendance the same as absenteeism?
They are opposites: attendance % + absence % = 100%.
Can I calculate attendance for a class?
Yes — use the team option with students instead of employees.
Does remote work count toward attendance?
Yes — for remote staff, attendance means being available during agreed working hours, usually shown by clock-in or timer records.
Should attendance affect pay?
Pay follows hours worked; attendance programs should not reduce pay for time actually worked.
How do I calculate attendance percentage in Excel?
Use =present/scheduled and format as a percentage. For a team, sum present days and scheduled days first.
What is 95% attendance in days?
Missing no more than 1 day in 20 — about 12 days in a 245-day work year.
What is 90% attendance in days?
Missing 2 days in every 20, or about 24 days a year.
Do sick days count against attendance?
They reduce the attendance rate, but protected leave must not be used against employees in attendance policies.
How do I calculate attendance for a training course?
Sessions attended ÷ sessions scheduled × 100. Many courses require a minimum such as 80% or 90%.
How do I calculate attendance for shift workers?
Count scheduled shifts rather than days: shifts attended ÷ shifts scheduled × 100. Swapped shifts count as attended if the swap was approved.
Should late arrivals count against attendance?
Usually not — attendance measures whether someone came to work. Track lateness separately with a tardiness rate so each problem gets the right response.
How do I calculate attendance for a month?
Days present in the month ÷ scheduled working days in the month × 100. A typical month has 20–23 working days.
Automate this with real tracked data.
StaffTiming records hours as they happen and turns them into payroll-ready timesheets, so you never re-type a calculation.