The Base Formula and What Goes in the Denominator

Attendance percentage = days present ÷ scheduled working days × 100. The formula is simple; the arguments about it are all in the denominator. Scheduled working days for a month are the calendar days minus weekly offs minus paid holidays declared by the company, for that employee's roster. For a 6-day-week employee in a 31-day month with 4 Sundays and 1 holiday, the denominator is 26. For a 5-day-week office employee in the same month it is 22 or 23. Using 30 or 31 as the denominator for everyone understates attendance for anyone with more offs and is the most common error.

Days present are the days on which the employee actually attended work, including on-duty or outdoor-duty days (OD) where the employee was working at a client site or in the field. Weekly offs and holidays do not count as present because they are not in the denominator either. A person who attended all 26 scheduled days is at 100 percent; one who attended 24 is at 92.3 percent.

Decide the reference period. Monthly is standard for payroll and reporting; quarterly or annual figures smooth out a single bad month and are better for appraisal. Whatever the period, the denominator must be that employee's scheduled days in that period, taken from the roster, not from a company-wide constant. The attendance percentage glossary entry states the definition in one paragraph if you need to align teams on it.

• Attendance % = present days ÷ scheduled working days × 100
• Denominator = calendar days − weekly offs − paid holidays, per employee roster
• Present includes on-duty / field days; excludes WO and H
• Use the employee's own scheduled days, never a fixed 30

Half-Days, Paid Leave, Comp-Off and Other Edge Cases

Half-days count as 0.5 present. An employee with 24 full days and 2 half-days in a 26-day month has 25 present days, or 96.2 percent. Late marks that your policy converts into half-days (for example, every third late mark) should be applied before the percentage is computed so that the figure reflects policy, not raw punches.

Paid leave is the design decision. There are two defensible conventions. Convention A (presence-based): paid leave is not present, so attendance percentage falls when leave is taken; this measures physical availability and suits operations planning. Convention B (compliance-based): approved paid leave is removed from the denominator, so a person who took 2 days of sanctioned casual leave and attended the other 24 is at 100 percent; this measures adherence to the attendance policy and suits incentive schemes, because it does not penalise people for using leave they are entitled to. Pick one, write it in the policy, and use it consistently.

Comp-off taken as leave follows the same convention as paid leave. Unpaid leave (LOP) and unauthorised absence are never removed from the denominator. Holidays declared mid-month remove a day from the denominator for everyone scheduled that day. For a joiner or leaver, use only the days between the joining date and month end (or the last working day) as the denominator. Maternity leave and long medical leave are usually excluded from the period entirely so that the percentage remains meaningful.

• Half-day = 0.5 present; apply late-mark conversion first
• Choose presence-based or compliance-based treatment of paid leave and document it
• LOP and unauthorised absence always reduce the percentage
• Pro-rate for joiners and leavers; exclude long statutory leave

Department, Site and Company-Level Percentages

Roll-ups are ratios of sums, not averages of percentages. Department attendance % = total present days of all employees in the department ÷ total scheduled days of all employees × 100. Averaging individual percentages gives a different and misleading number when employees have different scheduled days (a 5-day office team and a 6-day field team in the same department). Compute site and company figures the same way.

Compare like with like. A security site running 12-hour duties and a corporate office have different structural absence patterns; a company-level percentage that mixes them hides the site that needs attention. Report per site and per department and then the consolidated figure, and show headcount beside each so that a 100 percent from a three-person team is read in context.

Trend the figure. A department that moves from 96 percent to 91 percent over three months is telling you something about supervision, transport, or a roster that is quietly breaking people. Pair the attendance percentage with its complement, the absenteeism rate, which is easier to decompose into planned and unplanned absence; that is covered in the employee absenteeism rate formula and reduction article.

• Roll-up % = sum of present days ÷ sum of scheduled days, not an average of percentages
• Report by site and department before consolidating
• Show headcount next to every percentage
• Track the trend; pair with absenteeism rate for diagnosis

Attendance Percentage in Excel

In a monthly grid with codes P, A, HD, L, WO, H and OD in D4:AH4 for one employee, scheduled days = =COUNTA(D4:AH4)-COUNTIF(D4:AH4,“WO”)-COUNTIF(D4:AH4,“H”). Present days = =COUNTIF(D4:AH4,“P”)+COUNTIF(D4:AH4,“OD”)+0.5*COUNTIF(D4:AH4,“HD”). Attendance % = present ÷ scheduled, formatted as a percentage. Type straight double quotes in Excel; they are shown here as typographic quotes. If you use the compliance-based convention, also subtract COUNTIF(D4:AH4,“L”) from the denominator.

For a department roll-up, use SUMIF on the department column against the present-days and scheduled-days columns, then divide. Wrap the division in IFERROR to handle a department with zero scheduled days (all on long leave). Conditional formatting below a threshold, say 90 percent in red and 90 to 95 in amber, makes the exceptions visible. The monthly attendance sheet Excel template has these columns pre-built, and the attendance percentage calculator gives you a quick check for one employee without opening a workbook.

Watch for blanks. A blank cell in the grid is neither present nor absent, and COUNTA will still count it if it contains a space. Add a check that the sum of all codes equals the number of days in the month for each employee before you trust the percentage.

• Scheduled = COUNTA − WO − H (− L under the compliance convention)
• Present = P + OD + 0.5 × HD
• Roll-up with SUMIF by department, then divide
• Validate that code counts sum to the days in the month

Benchmarks, Attendance Bonus and Common Pitfalls

There is no statutory attendance percentage. Many Indian operations teams set an internal target of around 95 percent for shift and field workforces and treat anything under 90 percent for a department as a signal to investigate; office teams with liberal leave often run lower on the presence-based convention and higher on the compliance-based one. Set your benchmark by looking at your own last twelve months by department, and set it separately for each convention you use. Do not import a figure from another industry.

Attendance bonus schemes typically pay a fixed amount or a percentage of basic when an employee meets a monthly attendance threshold, with a smaller tier for a near-miss. A workable structure is: 100 percent attendance (compliance-based, paid leave excluded, at most one late mark) earns the full bonus; 96 to 99.9 percent earns half; below 96 earns none. State how half-days, late marks and comp-offs are treated, and remember that under the Code on Wages an allowance that is paid regularly to everyone can be pulled into 'wages' for PF and other purposes if excluded components exceed 50 percent of total remuneration; the structuring is discussed in salary structure components in India.

The pitfalls are consistent: using a fixed denominator, averaging percentages, applying the wrong leave convention to an incentive, computing from unvalidated punches (a missed punch-out becomes an absent day), and changing the definition without telling employees. Compute from the corrected attendance record after regularisation is closed, and publish the definition with the number. Attend Mitra's analytics computes attendance percentage per employee, department and site from the roster and the validated attendance record, with the paid-leave convention you configure, and exports it into the monthly attendance report.

• Set benchmarks from your own history, per department and per convention
• Attendance bonus: define the threshold, tiers, and treatment of HD, late and comp-off
• Compute after regularisation closes, from validated records
• Publish the definition alongside the figure every month