Download a free School Attendance Excel Sheet Template to easily record and manage student attendance. This ready-to-use Excel template helps schools and teachers track student names, class details, attendance dates,
present and absent records, leave, and attendance percentages in a simple and organized format. It is useful for maintaining accurate attendance records and monitoring student attendance throughout the academic year.
Key Features :
- S.No.
- Date
- Student ID
- Student Name
- Class
- Section
- Status
- Check-in Time
- Attendance %
- Remarks
- Dashboard
- KPI Card
- Bar Chart
- Pie Chart
Formulas :
Attendance %
=IF(OR(G5=”Present”,G5=”Late”),1,IF(G5=”Half Day”,0.5,0))
Total Records =COUNTA(‘Attendance Register’!$C$5:$C$1000)
Present =COUNTIF(‘Attendance Register’!$G$5:$G$1000,”Present”)
Absent =COUNTIF(‘Attendance Register’!$G$5:$G$1000,”Absent”)
Late =COUNTIF(‘Attendance Register’!$G$5:$G$1000,”Late”)
Half Day =COUNTIF(‘Attendance Register’!$G$5:$G$1000,”Half Day”)
Leave =COUNTIF(‘Attendance Register’!$G$5:$G$1000,”Leave”)
Average Attendance =IFERROR(AVERAGE(‘Attendance Register’!$I$5:$I$1000),0)
