An attendance sheet Excel template is a monthly register that marks each employee present, absent, on leave, or on a week-off for every day, then totals the days automatically. This free attendance sheet for Indian businesses uses a 30-day grid with COUNTIF formulas, so present days, LOP days, and attendance % update the moment you fill a code. Use it for a small team, then move to biometric or GPS attendance once manual marking gets slow.

Free Attendance Sheet Excel Template for Indian Businesses

An attendance sheet Excel template is a monthly register that marks each employee present, absent, on leave, or on a week-off for every day, then totals the days automatically. This free attendance sheet for Indian businesses uses a 30-day grid with COUNTIF formulas, so present days, LOP days, and attendance % update the moment you fill a code. Use it for a small team, then move to biometric or GPS attendance once manual marking gets slow.

What a Attendance Sheet Excel Template must include

  • Employee ID, name, and department
  • One column per calendar day (1 to 30 or 31)
  • A clear code legend: P present, A absent/LOP, L paid leave, WO week-off, H holiday
  • Auto totals: present days, paid leave, LOP days, week-offs
  • Payable days and attendance % per employee
  • One row per employee, one sheet per month

Drafting tips

  • Freeze the first three columns and the header row so names stay visible as you scroll across 30 days.
  • Use Data Validation to restrict each day cell to P, A, L, WO, or H. It stops typos that break the COUNTIF totals.
  • Keep one sheet (tab) per month and never overwrite last month. You will need the history for PF, ESI, and any LOP dispute.

Attendance Sheet Excel Template format

MONTHLY ATTENDANCE REGISTER for [Month YYYY]

Codes:  P = Present  |  A = Absent (LOP)  |  L = Paid Leave  |  WO = Week Off  |  H = Holiday

Mark one code per employee per day across columns 1 to 30. The summary columns total
themselves with COUNTIF, so present days, leave, LOP, and attendance % update live.

KEY FORMULAS (row 2 example)
Present Days   = COUNTIF(D2:AG2,"P")
Paid Leave     = COUNTIF(D2:AG2,"L")
Absent / LOP   = COUNTIF(D2:AG2,"A")
Week Offs      = COUNTIF(D2:AG2,"WO")
Payable Days   = Present + Paid Leave + Week Offs
Attendance %   = ROUND(Payable Days / 30 * 100, 0)

LOP salary impact = (Monthly Gross / Days in Month) x LOP Days

FAQs

What is an attendance sheet in Excel?

It is a monthly grid with one row per employee and one column per day. You mark a code (present, absent, leave, week-off) in each cell, and summary columns total the days so you know payable days and attendance % for payroll.

How do I calculate attendance percentage in Excel?

Divide payable days by the days in the month and multiply by 100: ROUND(Payable Days / 30 * 100, 0). In this template the Attendance % column already does it for every employee.

How do I count present days automatically?

Use COUNTIF over the day range, for example COUNTIF(D2:AG2,"P") counts every cell marked P in row 2. The template uses the same pattern for leave, LOP, and week-offs.

How does attendance affect salary?

Unpaid absence is loss of pay (LOP). The deduction is (Monthly Gross / Days in Month) x LOP Days. Paid leave and week-offs stay payable, so only the A-coded days reduce salary.

Can Excel track attendance for 100 employees?

It can, but daily manual marking becomes the bottleneck and a single mis-typed code skews the totals. Past roughly 30 to 50 employees most teams switch to biometric or GPS attendance that feeds payroll directly.

When should I move from an attendance sheet to attendance software?

When you have field or multi-shift staff, when manual marking takes more than a few minutes a day, or when LOP disputes start appearing. Indian HRM captures GPS-selfie or biometric punches and pushes payable days straight into payroll.