Student Attendance Sheet Weekly Monthly

  • Version
  • 9'346 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?

Employee Attendance Tracker

11.2 Mb / 57871 downloads
Shift Planner with Attendance Tracker

Weekly Attendance Sheet

14 KB / 3732 downloads
Training Attendance Sheet

13 KB / 4941 downloads
Sunday School Attendance Sheet

27 KB / 5015 downloads
Monthly Attendance Sheet

18 KB / 6708 downloads
Meeting Attendance Sheet

13 KB / 3755 downloads
Homeschool Attendance Sheet

16 KB / 3840 downloads
Girl Scout Attendance Sheet

16 KB / 3348 downloads
View Comments