How to calculate attendance percentage

Updated: 2026-10-15

The attendance percentage formula

attendance percentage = attended ÷ held × 100

If 40 classes were held and you attended 32, calculate 32 ÷ 40 × 100. Your attendance is 80%.

Two more examples

If you attended 27 of 36 classes, 27 ÷ 36 × 100 gives 75%. If you attended 17 of 24, the result is 70.83%. Classly displays percentages by rounding down to two decimal places so a value just below a required threshold is not shown as if it met the threshold.

Excel and Google Sheets formula

Put classes attended in cell A2 and classes held in B2, then use =A2/B2*100. Format the result as a number, or use =A2/B2 and format the cell as a percentage.

What belongs in each number?

• Held: every class that actually took place, including classes you missed.
• Attended: only classes where you were present.
• Cancelled: normally leave these out because the class did not take place.

Rules vary by institution, especially for medical leave and justified absences. Check your own policy before deciding whether a particular class belongs in either total.

How to calculate how many classes you can miss

Your current percentage does not directly tell you how many future classes you can miss, because every missed class increases the total held while the attended number stays unchanged. Use this formula:

classes you can miss = ⌊ attended × 100 ÷ target − held ⌋

Suppose you attended 34 of 40 classes and your target is 75%. The calculation is 34 × 100 ÷ 75 − 40 = 5.33. Round down, so you can miss 5 more classes. After those classes your attendance is 34 of 45, or 75.55%. Missing a sixth class would make it 34 of 46, or 73.91%, which is below the target.

How to calculate the classes needed to recover

If your percentage is below target, attending a new class increases both the attended and held numbers. That is why recovery may take longer than expected. For a target written as a decimal, use:

classes needed = ⌈ (target × held − attended) ÷ (1 − target) ⌉

For example, 20 attended out of 30 is 66.66%. With a 75% target, (0.75 × 30 − 20) ÷ 0.25 = 10. You need to attend 10 classes in a row, reaching 30 of 40, to return to exactly 75%.

Common calculation mistakes

• Do not divide absences by classes held; attendance percentage uses classes attended.
• Do not remove a class simply because you missed it. If it took place, it remains in the denominator.
• Calculate each subject separately when your institution checks subject-wise attendance.
• Do not assume 74.5% will be rounded to 75%. Use the exact result unless your rules explicitly allow rounding.

A calculator is useful for checking the arithmetic, but the target and the treatment of cancelled, justified, laboratory, or make-up classes must come from your own syllabus or institution.

How often should you update the calculation?

Update it whenever a class is held, not only after an absence. If you attend the class, add one to both attended and held. If you miss it, add one only to held. If the class is cancelled and your institution does not count cancellations, change neither number. This small routine keeps the result aligned with the actual timetable.

Compare your record with the official portal regularly. A missing attendance mark, a late timetable change or a laboratory recorded separately can change the result. Raise discrepancies while the class is recent rather than waiting until examination eligibility is checked.

Percentage versus percentage points

Moving from 60% attendance to 75% means gaining 15 percentage points, but it does not mean attending only 15 more classes. New classes enlarge the denominator, so the required number depends on how many classes have already been held. A student at 12 of 20 and one at 30 of 50 are both at 60%, yet the first needs 12 consecutive classes to reach 75% while the second needs 30.

Keep the counts alongside the displayed percentage. The pair “32 of 40” is more useful for planning than “80%” alone because it preserves the numbers needed for every future calculation.

Turn the calculation into a planMark each class, simulate what happens next, then keep your timetable and tasks together. Free, offline-first, no Classly account.

App StoreGoogle Play

More attendance tools

Common questions