Student Attendance Sheet Weekly Monthly

  • Version
  • 7'042 Downloads
  • 69 KB File Size
  • July 15, 2009 Updated
  • 5 Number of comments
  • Yes Free
  • 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?

Weekly Attendance Sheet

14 KB / 1225 downloads
Training Attendance Sheet

13 KB / 1207 downloads
Sunday School Attendance Sheet

27 KB / 958 downloads
Monthly Attendance Sheet

18 KB / 1685 downloads
Meeting Attendance Sheet

13 KB / 1390 downloads
Homeschool Attendance Sheet

16 KB / 980 downloads
Girl Scout Attendance Sheet

16 KB / 1058 downloads
Employee Attendance Sheet

18 KB / 1479 downloads
Daycare Attendance Sheet

35KB / 1148 downloads
View Comments