How to

How To Create Excel Attendance Spreadsheet Template For Classroom

Add Columns for Date

After add labels for ID and student’s name, we can add columns for dates. If this is going to be weekly attendance sheet, you can add 7 columns for the date. If this is going to be monthly attendance sheet, then you can 23 columns more.

You can format the date by right-click and opt format cells and choose date in the category section and feel free to custom it with your style. Don’t forget to remove Sunday and Saturday in this by click on the tiny box that populates at the end of your date range and select “Fill Weekdays.”