Attendance percentage sounds like something you'd do in your head. Then you try it. Does a Sunday count? What about the person who left at lunch? Ask three colleagues and you'll get three answers that don't match.
The maths is one line. The arguments are about what goes into that line. So this post walks through the formula, three worked examples (a month, a quarter, a year), how half days and leave change things, and how colleges handle all this compared with companies. There's also a shortcut for the 75 percent rule that students keep asking about. It's written for HR managers, business owners and employees in India, though students will get plenty out of it too.
Attendance percentage equals days present divided by total working days, times 100. If you were in on 22 of 26 working days, you get 22 / 26 x 100, which is roughly 84.6 percent. The same formula covers employees, students and any period you want to check.
Four steps:
So 22 present and 26 working days gives 0.846, and 0.846 x 100 is 84.6 percent.
Most mistakes happen at step one. People divide by every day in the month, Sundays included, and then the percentage looks oddly low and somebody in payroll gets a phone call.
The formula stays the same for a month, a quarter or a year. Only the totals change. Twenty-two present out of 26 working days is 84.6 percent. Seventy out of 78 across a quarter is 89.7 percent. And 276 out of 300 across a full year comes to 92 percent.
Monthly. A 30-day month with 4 Sundays off leaves 26 working days. The employee came in for 22.
22 / 26 x 100 = 84.6 percent.
Quarterly. Three months with 26, 25 and 27 working days, so 78 in all. The employee attended 24, 22 and 24 days, which makes 70.
70 / 78 x 100 = 89.7 percent.
Don't average the three monthly percentages. It's tempting, and it gives you a slightly wrong answer. Add up the days first, then divide once.
Yearly. Say there are 300 working days after weekly offs and holidays, and the employee was present for 276.
276 / 300 x 100 = 92 percent. That's 24 days absent.
Same formula, three times. Only the numbers underneath moved.
Take weekly offs and public holidays out of your working days, and count a half day as 0.5. Paid leave is the awkward one, because companies treat it differently. Choose a rule, apply it to everyone, and put it in writing, since this one decision can move the result by several points.
Let's try a month. It has 30 days, 4 Sundays and 1 public holiday, so 25 working days. The employee has 20 full days, 3 half days and 2 days of approved paid leave.
Present days: 20 + (3 x 0.5) = 21.5.
If paid leave doesn't count as present, that's 21.5 / 25 x 100 = 86 percent. If it does, you add the 2 days and get 23.5 / 25 x 100 = 94 percent.
Eight points apart, and nobody did anything different. Only the policy changed. That's why attendance disputes are so often about definitions, not arithmetic.
A few smaller calls you'll want to settle early. Unpaid leave and loss of pay days count as absent. Work from home counts as present if your policy says it does. And late arrivals usually stay full days, unless you've decided that, say, three lates in a month turn one into a half day.
If you track hours instead of days, our guide on how to calculate working hours picks up from here.
Employees are measured against working days, with weekly offs and holidays taken out. Students are measured against the classes actually held, often subject by subject. Same formula, different denominator, and that's usually where the confusion starts when someone moves between the two.
For employees, HR uses the number for payroll, bonuses, leave accrual and reviews. The denominator is working days, or sometimes paid days.
For students, it's classes held, not days in the term. Go to 54 of 72 lectures and you're at 54 / 72 x 100 = 75 percent. Plenty of colleges work this out per subject, which means one weak subject can keep you out of an exam even when your overall number looks perfectly fine.
There's another difference, and it's a bit cruel. An employee can sometimes make up lost time. A student can't. A missed lecture stays missed, and the cushion gets thinner every week.
Most Indian colleges want 75 percent attendance before you can sit exams, though your own university sets the exact rule. For employees, the Code on Wages generally asks for at least 30 days worked in the accounting year before bonus eligibility kicks in. Other thresholds depend on the law covering your workplace.
On the college side, 75 percent is the usual benchmark but it isn't one national number. Some bodies allow condonation with a medical certificate, and the limits differ. Check your university's rules and theUGC guidelines for the student angle.
For companies, attendance feeds into several decisions. Bonus is the big one. It now sits in Chapter IV of the Code on Wages, 2019, which replaced the Payment of Bonus Act, 1965 from 21 November 2025. An employee gets the annual minimum bonus if their wages are within the notified ceiling and they've worked at least 30 days in the accounting year. Look up the current ceiling before you rely on it.
Annual and earned leave are tied to days worked too, but the threshold depends on which law covers your establishment, so confirm before you quote a number. Perfect attendance rewards are purely a company call. Define them clearly. And plenty of employers glance at attendance before confirming someone after probation.
Labour rules are still settling as the new codes roll out, and states add their own details. The Ministry of Labour publishes resources on wages and working days at labour.gov.in. Check there before you lean on any threshold. This is general information, not legal advice.
The free calculator at the top of this page does the sum for you. Enter the total working days and the days present, and the percentage appears straight away. There's also an Excel template below if you'd rather keep a running monthly record. More tools live in our free HR and attendance tools hub.
[DOWNLOAD PLACEHOLDER: Attendance percentage Excel template]
In Excel or Google Sheets, put days present in B2 and total working days in C2. Then type =B2/C2*100. Or type =B2/C2 and format the cell as a percentage, either works. If you want a ready-made layout for marking attendance daily.
Now the trick for students. How many more classes do you need to reach 75 percent? You don't need a calculator.
Classes needed = 3 x classes held − 4 x classes attended
Say 90 classes have run and you've attended 60. You're at 66.7 percent. So it's 3 x 90 − 4 x 60 = 270 − 240 = 30 more classes, with no absences. Test it: 90 out of 120 is exactly 75 percent.
It only works for a 75 percent target, mind. For any other number, rework the algebra or use the calculator.
Attendance software works out the percentage every day from punch data, applies your half day, holiday and leave rules automatically, and flags people who are slipping below the line. That takes the arithmetic, and the month-end spreadsheet scramble, off your plate. Nobody has to count anything by hand.
Doing it manually is fine for ten people. Around fifty it starts to hurt, because somebody's chasing missing punches, applying leave rules and rebuilding the numbers every month. Software handles most of that, since the percentage updates itself as people punch in.
Attendance percentage is one of such formulas: number of days attended divided by total working days, multiplied by 100%. The rest is just an interpretation of what is considered a working day, a half day and paid time off. Set the rules once, put it in writing, and numbers will no longer be disputed.
If you can remember only three things, let these be the following. Exclude weekly offs and holidays from the denominator. Sum the number of days first, rather than average percentages. And review your own college or workplace policies, because 75% and 30 days are popular standards but not universal ones.
Got curious to apply all these principles to your numbers? Open the attendance percentage calculator or download the Excel template
Divide days present by total working days, then multiply by 100. If you were present for 22 of 26 working days, that's 22 / 26 x 100, or about 84.6 percent.
With days present in B2 and total working days in C2, type =B2/C2*100. You can also type =B2/C2 and format the cell as a percentage.
A half day counts as 0.5 present. Total up your half days, multiply by 0.5, and add the result to your full days before dividing.
Most Indian colleges ask for 75 percent, but your university or regulator sets the real rule. Some allow condonation with a medical certificate. Check your own institution.
Use 3 x classes held − 4 x classes attended. If 90 classes were held and you've attended 60, you need 30 more classes without missing any.