Student Attendance Sheet Weekly Monthly

  • Version
  • 9'473 Downloads
  • 69 KB File Size
  • January 4, 2022 Updated
  • 5 Number of comments
  • Rating

These student attendance records is created to help teachers keep track of attendance of their students. There are two models created here, weekly and monthly records.

Weekly Attendance Record

This spreadsheet is a simple form that can be used for record the attendance of students for five days period. The formula being used here is the basic sum formula that will sum the student attendance based on its category.

Weekly Attendance Record

Monthly Attendance Record

This spreadsheet is created with excel formula and conditional formatting which will give you the customize record or report that can be used monthly. Set your targeted month and year, and the date column will adjust automatically to give you the day name of the given date. And there is conditional formatting in the column that will turn the cell color into grey color if the given date is Sunday or holiday. The holiday itself will refer to the date in the holiday worksheet where you can custom it.

Monthly Attendance Record

Those spreadsheets above are basic spreadsheets that you can personalize to suit your own needs. You can modify its automatic color appearance by tweaking the conditional formatting formula that is used to built them.

How useful was this template?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 80

No votes so far! Be the first to rate this template.

We are sorry 🙁

Help us improve!

How we can improve this template?

Shift Planner with Attendance Tracker

Employee Attendance Tracker

11.2 Mb / 58068 downloads
Weekly Attendance Sheet

14 KB / 3825 downloads
Training Attendance Sheet

13 KB / 5200 downloads
Sunday School Attendance Sheet

27 KB / 5192 downloads
Monthly Attendance Sheet

18 KB / 7107 downloads
Meeting Attendance Sheet

13 KB / 3863 downloads
Homeschool Attendance Sheet

16 KB / 3960 downloads
Girl Scout Attendance Sheet

16 KB / 3412 downloads
View Comments