Guide

How to Calculate Attendance Percentage (and the 75% Rule)

Updated · 2 min read

The attendance percentage formula, how many classes you can miss and how many you must attend to reach 75% or any target, with worked examples and an Excel formula.

On this page

Most schools and colleges require a minimum attendance, often 75%. Working out where you stand takes one division, and knowing how many classes you can still miss takes one more step.

The formula

Attendance % = classes attended ÷ classes held × 100. If 40 classes were held and you attended 28, then 28 ÷ 40 × 100 = 70%.

How many classes can I miss?

If you are already above the requirement, the number of further classes you can miss is the largest whole number y with attended ÷ (held + y) ≥ the required percentage. With 40 held and 32 attended (80%) and a 75% rule, you can miss 2 more classes: 32 ÷ 42 = 76.2%, but 32 ÷ 43 = 74.4%.

How many classes must I attend to reach 75%?

If you are below the requirement, attend the next x classes in a row, where (attended + x) ÷ (held + x) ≥ the target. With 40 held and 28 attended, you need 8 in a row: 36 ÷ 48 = 75%. The closed form is x = ⌈(r × held − 100 × attended) ÷ (100 − r)⌉. At a 100% requirement a missed class can never be made up.

What 75% means over a month or a term

In a 30-day month with classes every day, 75% means at least 23 days (22.5 rounded up) and at most 7 missed. For a whole term of T classes you must attend at least ⌈0.75 × T⌉. For 80 classes that is 60 attended and 20 that can be missed.

Do it in Excel

Put attended in A2 and held in B2. Use =A2/B2*100 for the percentage and =ROUNDDOWN(A2*100/75-B2,0) for the classes you can still miss at 75%.

Let the calculator do it

The attendance calculator gives the percentage, the classes you can miss and the classes you need, and it also accepts a term total and your own required percentage. Rules differ between institutions, so check the minimum and the rules on medical leave in your own handbook.

Working with dates instead? See how to calculate age and the difference between dates.

Try the tools

More guides