Absence Percentage Calculator
Enter days absent and total days to get your absence percentage and attendance rate — with show-your-work steps, school & workplace interpretation bands, and a reverse planner that tells you how many days you can still miss.
100% client-side — your numbers never leave your browser–
Absence percentage
–
Attendance rate
–
Days present
–
Absence percentage
–
Attendance rate
–
Days present
▸ Related metric: the Bradford factor
Absence percentage answers “how much time was missed”. Many HR departments also use the Bradford factor, which answers “how disruptive was the pattern”:
Bradford factor = S² × D · S = separate absence spells, D = total days absent
Ten one-day absences score 10² × 10 = 1,000, while one ten-day absence scores 1² × 10 = 10 — identical absence percentage, very different Bradford score. Widely used trigger points are 51+ (note concern), 125+ (formal procedure), 400+ (potential dismissal), though every employer sets its own. Try our Bradford factor calculator →
–
Max days you can miss
–
That is absence %
–
Attendance if you miss that many
▸ The math
Absence % = (days absent ÷ total days) × 100
Attendance rate = 100 − absence %
Max days you can miss = ⌊ (100 − target attendance %) ÷ 100 × total days ⌋
Two edge cases are handled honestly: a period of zero days makes the percentage undefined (you cannot divide by zero), and entering more absent days than total days is rejected — absence percentage can never exceed 100%.
▸ What your number means
School
| Absence % | Attendance | Interpretation |
|---|---|---|
| Below 5% | 95%+ | Excellent — meets the bar most schools expect. |
| 5% – 10% | 90–95% | Monitor — below 95% attendance, many schools flag this range. |
| 10% or more | Below 90% | Chronic absenteeism (US Dept. of Education: missing ≥10% of the school year). In England, attendance below 90% is persistent absence. |
Workplace (rough employer guide — no universal standard; your employer's policy governs)
| Absence % | Interpretation |
|---|---|
| Below 1.5% | Low — well below typical averages. |
| 1.5% – 3% | Typical — around the average for full-time employees. |
| 3% – 5% | Above average — worth understanding the cause. |
| Above 5% | High — likely to trigger a formal attendance review. |
▸ Worked examples
Example 1 — school: 9 days absent out of a 180-day US school year.
(9 ÷ 180) × 100 = 5.00% absence → 95.00% attendance — excellent.
Example 2 — the 10% line: 19 days absent out of a 190-day English school year.
(19 ÷ 190) × 100 = 10.00% absence → 90.00% attendance — the chronic/persistent-absence threshold.
Example 3 — work: 8 days absent out of 260 workdays.
(8 ÷ 260) × 100 = 3.08% absence → 96.92% attendance — just above typical.
Example 4 — reverse: 180-day year, target 95% attendance.
⌊0.05 × 180⌋ = 9 days — miss a 10th and you drop to 94.44%.
▸ Frequently asked questions
What is the formula for absence percentage?
Absence percentage = (days absent ÷ total days) × 100. Divide the number of days absent by the total number of days in the period (school term, semester, or work period), then multiply by 100. Example: 9 days absent out of a 180-day school year → (9 ÷ 180) × 100 = 5.0% absence.
How do you calculate absence percentage for school?
Count the days the student was absent during the term or school year, count the total school days in that same period, then apply (absent ÷ total) × 100. A typical US school year has 180 days and a typical English school year has 190 days — both are one-tap presets in the calculator above. Half-days count as 0.5.
What is attendance rate, and how does it relate to absence percentage?
Attendance rate is the complement of absence percentage: attendance rate = 100 − absence %. If a student is absent 5% of the time, their attendance rate is 95%. Schools usually report attendance rate, while HR and truancy discussions usually report absence percentage — they are two views of the same number, and the calculator shows both.
What absence percentage counts as chronic absenteeism?
In the United States, the Department of Education defines chronic absenteeism as missing 10% or more of the school year — for a 180-day year that is 18 days or more, excused or unexcused. An absence percentage of 10% or higher is therefore the standard red-flag threshold in US schools.
What is persistent absence in UK schools?
In England, the Department for Education defines persistent absence as attendance below 90% — in other words, an absence percentage above 10%. For a 190-day English school year, that means missing more than 19 days. Schools monitor pupils at or below 90% attendance closely and may involve education welfare services.
What is a good absence percentage at work?
There is no universal legal standard — it varies by employer, industry, and country — but as a rough guide used by many employers: below 1.5% is low, 1.5–3% is around typical for full-time employees, 3–5% is above average and worth investigating, and above 5% is high and likely to trigger a formal attendance review. Always check your own employer's attendance policy, which is what actually applies to you.
How many days can I be absent and still keep 95% attendance?
Use the reverse planner: maximum absent days = floor((100 − target attendance %) ÷ 100 × total days). For a 180-day school year at a 95% target: floor(0.05 × 180) = 9 days. The planner tab above computes this for any total and any target, and verifies the resulting percentage.
Can absence percentage be more than 100%?
No. You cannot be absent for more days than exist in the period, so absence percentage is capped at 100% (absent every single day). If you enter more absent days than total days, the calculator shows an honest error instead of a meaningless number above 100%.
Do half-days and excused absences count toward absence percentage?
Half-days count as 0.5 — the calculator accepts decimal inputs for exactly this reason. Whether excused absences (illness with a note, medical appointments) count depends on the policy: US chronic-absenteeism statistics include excused absences, while many employer Bradford-factor schemes count every spell regardless of reason. Enter whatever your school or employer counts, and be consistent.
What is the Bradford factor, and how is it different from absence percentage?
The Bradford factor is a separate HR metric that measures the disruptiveness of absence: Bradford factor = S² × D, where S is the number of separate absence spells and D is the total days absent. Ten one-day absences score 10² × 10 = 1,000, while one ten-day absence scores 1² × 10 = 10 — same absence percentage, very different Bradford score. Absence percentage answers 'how much time was missed'; Bradford answers 'how disruptive was the pattern'. Widely used trigger points are 51+ (note concern), 125+ (formal procedure), and 400+ (potential dismissal), though every employer sets its own.
How do I calculate absence percentage in Excel or Google Sheets?
If absent days are in A1 and total days in B1, use =A1/B1*100 and format the cell as a percentage or number with two decimals. For attendance rate use =1-A1/B1. To guard against a zero total, use =IF(B1=0,"n/a",A1/B1*100). For the reverse planner (max days absent at 95% attendance): =FLOOR(0.05*B1,1).
Does a high absence percentage affect grades or employment?
It can. Research consistently links chronic absenteeism (10%+) with lower test scores and higher dropout risk, and many schools tie exam eligibility or course credit to attendance thresholds. At work, repeated high absence can lead through informal review to formal warnings and ultimately dismissal under most attendance policies. This calculator is for information only — your school's or employer's written policy is what governs your situation.
Free tool by NRTechStudio