Student Attendance Sheet Weekly Monthly
- 11'009 Downloads
- 69 KB File Size
- January 4, 2022 Updated
- 5 Number of comments
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.
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.
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.
We are sorry 🙁
Help us improve!
How we can improve this template?
Nancy ( )
I found the yearly student attendance sheet yesterday but can’t find it today!
brooklyn ( )
i need one now
Vasava Champak ( )
these are very good. but i want a format in which i can enter the personal information of students like contact, address etc.
Moeen Ahmad ( )
these are good. but i want a format in which i can enter the personal information of students like contact, address etc.
Stacy ( )
I like what I see but I need wider rows so I can do something like P for am/pm
I am looking into about 15 rows maybe 18. I need columns for five days a week so about 25 with a thin column seperating them. I need a wide column to print childrens full names. I also need three columns for things like birthdate/program/changes and one or two thin numbered columns.
This is as monthly transportation/attendance sheet for a day care center. I only want a 8 1/2 X 11 normal size. We have sheets but they have like 30 rows for kids names and we need less with wider rows.
Any ideas? I have tired and have failed repeatedly.