Attendance Percentage Calculator

An attendance calculator is a free online tool that tells you your attendance percentage from the number of classes you attended and the total number of classes held. It is useful for school students, college students, teachers who prepare monthly registers, and employees who track working days. You get an accurate result in seconds, without doing the maths by hand.

Most colleges and universities ask students to maintain at least 75% attendance to sit for exams. Instead of guessing how many classes you can still miss, or how many you must attend to recover, this page gives you the formulas, worked examples and ready-made tables to work it out yourself, along with the calculator above.

Attendance Percentage Formula

The formula is the same in schools, colleges and offices. Divide the number of classes (or days) you attended by the total number held, then multiply by 100.

For example, if a student attended 68 classes out of 80:

85% is above the usual 75% requirement, so this student is eligible in most institutions. The formula works for a week, a month, a semester or a full year, as long as both numbers cover the same period.

How to Calculate Attendance Percentage Step by Step

Do this for each subject and for the overall figure, and repeat it every few weeks instead of waiting for exam time. A small dip is easy to fix in week 6 and very hard to fix in week 16.

How to Calculate 75% Attendance

Three questions come up most often when you are close to the 75% line. Each one has a simple formula.

1. How many classes must I attend out of the total? Multiply the total number of classes by 0.75 and round up. For 100 classes, you need 75. For 90 classes, 0.75 × 90 = 67.5, so you need 68.

2. How many classes can I miss? Subtract the required number from the total. For 90 classes, 90 − 68 = 22 classes can be missed.

3. I am already below 75%. How many classes must I attend in a row to recover? Use this formula, where A is the classes you attended and T is the classes held so far:

The same idea works for any target. Replace 0.75 with 0.80 for an 80% rule and 0.25 with 0.20.

Planning a whole semester. If you know the total classes for the semester, work out what is left. Say the semester has 100 classes, 60 are over and you attended 50. You need 75 in total, so you must attend 25 of the remaining 40 classes, which means you can still miss 15.

If you stop attending completely. With A attended out of T held, the number of further classes you can skip is (4 × A − 3 × T) ÷ 3. With 68 of 80, that is (272 − 240) ÷ 3 = 10 classes, because 68 ÷ 90 is still above 75% but 68 ÷ 91 is not. Use this as a warning, not a plan.

75%, 80%, 85% and 90% Attendance Means How Many Days in a Month?

If your college or office checks attendance month by month, this table shows the minimum number of days you must be present for each percentage, depending on how many working days the month has. Values are rounded up, because you cannot attend part of a day.

So 85% attendance in a month with 24 working days means being present on at least 21 days. Some institutions round 74.5% up to 75% and some do not, so confirm the rule with your college or school office.

How to Calculate Average Attendance of the Month

"Average attendance" means two slightly different things depending on who is asking. Students usually want their own percentage. Teachers filling a school register want the average daily attendance of the whole class, along with the average number on roll. Here is how each one is calculated.

Method 1: Average daily attendance (school register method)

Average number on roll is worked out the same way, using the number of students enrolled on each day instead of the number present. It matters when students join or leave during the month. If nobody joined or left, the number on roll is the same every day and the average is simply that number.

Worked example (one week of a register): A class has 40 students on roll.

For a full month, the steps are identical. Add the present count for every working day, divide by the number of working days, then divide by the average number on roll. For example, a month with 24 working days, a total of 1,008 student-days present and an average of 48 on roll gives 1,008 ÷ 24 = 42, and 42 ÷ 48 × 100 = 87.5%. For a term or a whole year, add the monthly totals and divide by the total working days in that period.

Method 2: Student by student

Find each student's monthly percentage (days present ÷ working days × 100), then add all of them and divide by the number of students. When every student has the same number of working days, both methods give the same class average, so use whichever is easier with your data.

How to Calculate Attendance in Excel

For a class of 30 to 60 students, an Excel or Google Sheets register saves a lot of time. Put student names in column A and one column per date (B to AF for a 31-day month). Mark P for present, A for absent and H for a half day. Leave holidays blank. Then use these formulas:

In the example, AG holds days present, AH1 holds the number of working days and AI holds the percentage. Adjust the cell references to your own sheet. Add a conditional formatting rule that turns any percentage below 75% red, so short-attendance students stand out as soon as you open the file. If you also keep the daily present count row empty on holidays, AVERAGE will skip those days automatically.

How to Calculate Overall Attendance Percentage

When you have several subjects, combine the totals first. Do not average the subject percentages, because subjects with more classes should carry more weight.

Mathematics alone looks safe, but the overall figure is 72.6%, which is short. Many institutions also apply the 75% rule to each subject, so check both the overall and the subject-wise numbers before assuming you are eligible.

What to Do If Your Attendance Is Short

• Calculate exactly how far you are. Use the recovery formula above to see how many consecutive classes you need, then check whether enough classes are left in the semester.
• Collect proof for genuine absences. Medical certificates, hospital records, sports or event participation letters and approved leave letters are the documents most institutions accept.
• Apply for condonation early. Many colleges allow a condonation or shortage application when the shortfall is small and the reason is genuine. The limit, fee and last date are set by your institution, so ask the department office instead of relying on hearsay.
• Do not wait for the last week. Recovery is only possible while there are enough classes left to attend.

While you track attendance, you may also want to check your semester results with the SGPA Calculator, or the SRM CGPA Calculator if you study at SRM.

Common Mistakes While Calculating Attendance

Attendance Calculation for Employees and Offices

The formula is the same for employees: days present ÷ working days × 100. Payroll teams usually treat paid leave and approved work-from-home days as present and unpaid leave as absent, but this depends on company policy. Half days are normally counted as 0.5. If you are also tracking how long someone has worked in a company, you can use the Experience Calculator to find total service in years, months and days.

Related Calculators

You can see every tool on the CalcShala homepage.

Frequently Asked Questions

How do I calculate attendance percentage?
Divide the classes you attended by the total classes held and multiply by 100. For example, 68 out of 80 gives 85%.

How many days is 75% attendance in a month?
It depends on the working days. With 24 working days you need at least 18 days, with 26 working days you need 20 days, and with 30 days you need 23. See the table above for 80%, 85% and 90% too.

85% attendance means how many days in a month?
In a month with 24 working days, 85% means at least 21 days present. With 26 working days it is 23 days, and with 30 days it is 26 days.

How do I calculate the average attendance of the month?
Add up the number of students present on each working day and divide by the number of working days. To get a percentage, divide that average by the average number on roll and multiply by 100.

What is the average number on roll during the month?
It is the total of the daily enrolment numbers divided by the number of working days. If no student joined or left during the month, it equals the class strength.

What is the difference between average attendance and attendance percentage?
Average attendance is a head count, for example 37 students per day. Attendance percentage compares that number with the students enrolled, for example 37 out of 40, which is 92.5%.

How many classes must I attend to reach 75%?
Use (0.75 × classes held − classes attended) ÷ 0.25. If you attended 40 of 60 classes, you must attend the next 20 without missing any to reach exactly 75%.

Can I miss classes if my attendance is 80%?
Yes, but only a few. With 80 of 100 classes attended, you can skip about 6 of the next classes before dropping below 75%, as 80 ÷ 106 is 75.5% and 80 ÷ 107 is 74.8%.

Is overall attendance different from subject-wise attendance?
Yes. Overall attendance combines every subject, while subject-wise attendance is checked separately. Some institutions require 75% in both, so check each figure.

Is 74.5% attendance rounded up to 75%?
It depends on the institution. Some round up and many do not, so do not assume. Ask your department office, and keep decimals while calculating.

How do I calculate attendance in Excel?
Use =COUNTIF(range,"P") to count present days, divide by the working days and format the result as a percentage. The Excel section above shows the full set of formulas for a register.

What if my attendance is below the required percentage?
Calculate how many classes you need to recover, collect proof for genuine absences such as medical certificates, and apply for condonation if your institution allows it. Contact the department office as early as possible.

Attendance rules differ between schools, colleges and employers. The formulas on this page give the mathematical result, but eligibility is decided by your institution's own policy. Last updated: October 2026.