Attendance sheet · January 2027 · Excel and PDF

Attendance sheet for January 2027, ready to print

January 2027 has 31 days and 5 Sundays. Republic Day, 26 January, is the central gazetted holiday and is marked; add your state’s days from the holiday list. Each row totals present, absent, leave and LOP days, as on the template.

31 days, 5 Sundays; 26 January marked.

Download Excel (.xlsx)Download PDF

Days in January 2027: 31
Sundays (weekly off): 5
Central gazetted holiday: 26 Jan, Republic Day

Attendance sheet for January 2027: one row per person, one column per day, then the totals
Name	3 S	10 S	17 S	24 S	26 T	31 S
Meenal Joshi	WO	WO	WO	WO	H	WO
Asha Rao	WO	WO	WO	WO	H	WO
Rohan Das	WO	WO	WO	WO	H	WO
Vikram Nair	WO	WO	WO	WO	H	WO
Priya Menon	WO	WO	WO	WO	H	WO

Codes: P present · A absent · L leave · LOP · HD half day · WO weekly off · H holiday. The last four columns total each row (P, A, L, LOP), as on the template. Holiday: DoPT O.M. of 16 Jul 2026 (central list). Design preview · sample data

No. 01

Other months

Attendance sheets for other months

For employersLekhaHR is HR and payroll software for small Indian teams. See attendance →