Employee Attendance Sheet Excel Template

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX
1
2			Your Company Name
3			Emloyee Attendance Sheet
6	Year	2025	Date	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31	Monthly Attendance Summary
7	Month	January	Type of Day	W	W	W	W	H	W	W	W	W	W	W	H	W	W	W	W	W	W	H	W	W	W	W	W	W	H	W	W	W	W	W	Monthly Attendance Summary
8	Emp. ID	Employee Name	Month	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	P	L	HD	NH	FH	T	ML	EL	EL AL	SL	SL AL	CL	CL AL	Working Days	Days Payable

9	AS2101	Astha Puri	January	P	L	H	HD	HD	CL	T	NH	FH	H	ML	EL	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	17	1	2	1	1	1	1	1	1	0	2	1	2	26.00	25.00
10	AS2102	Bijal Pande	January	P	P	H	L	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	23	1	0	1	1	0	0	0	1	0	2	0	2	26.00	25.00
11	AS2103	Chirag Sharma	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	HD	P	P	P	P	H	P	P	P	P	P	P	H	23	0	1	1	1	0	0	0	1	0	2	0	2	26.00	26.00
12	AS2104	Divya Soni	January	P	P	H	P	P	HD	P	NH	FH	H	P	P	P	P	CL	P	H	P	P	P	P	P	P	H	P	P	CL	P	P	P	H	21	0	1	1	1	0	0	0	1	0	2	2	2	26.00	26.00
13	AS2105	Erum Rastogi	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	CL	P	P	P	H	P	P	L	P	SL	P	H	21	1	0	1	1	0	0	0	1	1	2	1	2	26.00	25.00
14	AS2106	Farhan Patel	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
15	AS2107	Geet Sahu	January	P	P	H	P	L	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	SL	P	P	H	P	P	P	P	P	P	H	22	1	0	1	1	0	0	0	1	1	2	0	2	26.00	25.00
16	AS2108	Himesh Surya	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	HD	P	P	P	P	H	P	P	L	P	P	P	H	22	1	1	1	1	0	0	0	1	0	2	0	2	26.00	25.00
17	AS2109	Imran Abha	January	P	P	H	P	L	P	P	NH	FH	H	P	P	P	SL	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	22	1	0	1	1	0	0	0	1	1	2	0	2	26.00	25.00
18	AS2110	Jitendra Pande	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	L	P	P	P	L	P	H	L	P	P	P	P	P	H	21	3	0	1	1	0	0	0	1	0	2	0	2	26.00	23.00
19	AS2111	Kailash Rane	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
20	AS2112	Luv Patel	January	P	P	H	P	L	P	P	NH	FH	H	P	P	L	P	P	P	H	P	HD	P	P	P	P	H	P	P	CL	P	P	P	H	20	2	1	1	1	0	0	0	1	0	2	1	2	26.00	24.00
21	AS2113	Manoj Bhide	January	P	P	H	P	P	P	P	NH	FH	H	L	P	P	P	P	P	H	T	T	T	T	T	T	H	P	P	P	P	SL	P	H	16	1	0	1	1	6	0	0	1	1	2	0	2	26.00	25.00
22	AS2114	Nancy Pastor	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	HD	P	H	ML	ML	ML	ML	ML	ML	H	17	0	1	1	1	0	6	0	1	0	2	0	2	26.00	26.00
23	AS2115	Omar Shaikh	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
24	AS2116	Preetam Chavla	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	HD	P	P	P	P	H	23	0	1	1	1	0	0	0	1	0	2	0	2	26.00	26.00
25	AS2117	Ram Vihaan	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
26	AS2118	Sunil Upadhay	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
27	AS2119	Tirth Chobe	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
28	AS2120	Umesh Bajrang	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	HD	P	P	P	P	H	23	0	1	1	1	0	0	0	1	0	2	0	2	26.00	26.00
29	AS2121	Umesh Bajrang 1	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
30	AS2122	Umesh Bajrang 2	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
31	AS2123	Umesh Bajrang 3	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
32	AS2124	Umesh Bajrang 4	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
33	AS2125	Umesh Bajrang 5	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	HD	P	P	P	P	H	23	0	1	1	1	0	0	0	1	0	2	0	2	26.00	26.00
34	AS2126	Umesh Bajrang 6	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
35	AS2127	Umesh Bajrang 7	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
36	AS2128	Umesh Bajrang 8	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	HD	P	P	P	P	H	23	0	1	1	1	0	0	0	1	0	2	0	2	26.00	26.00
37	AS2129	Umesh Bajrang 9	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
38	AS2130	Umesh Bajrang 10	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
39	AS2131	Umesh Bajrang 11	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
40	AS2132	Umesh Bajrang 12	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
41	AS2133	Umesh Bajrang 13	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
42	AS2134	Umesh Bajrang 14	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
43	AS2135	Umesh Bajrang 15	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
44	AS2136	Umesh Bajrang 16	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
45	AS2137	Umesh Bajrang 17	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
46	AS2138	Umesh Bajrang 18	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
47	AS2139	Umesh Bajrang 19	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
48	AS2140	Umesh Bajrang 20	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
49	AS2141	Umesh Bajrang 21	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
50	AS2142	Umesh Bajrang 22	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
51	AS2143	Umesh Bajrang 23	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
52	AS2144	Umesh Bajrang 24	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
53	AS2145	Umesh Bajrang 25	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
54	AS2146	Umesh Bajrang 26	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
55	AS2147	Umesh Bajrang 27	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
56	AS2148	Umesh Bajrang 28	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
57	AS2149	Umesh Bajrang 29	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
58	AS2150	Umesh Bajrang 30	January	P	P	H	P	P	P	P	NH	FH	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	P	P	P	P	P	P	H	24	0	0	1	1	0	0	0	1	0	2	0	2	26.00	26.00
59
60	Daily Attendance			50	49	0	48	46	48	49	0	0	0	48	49	49	49	49	50	0	48	46	48	48	47	49	0	48	45	45	49	47	49	0
61