Monthly Attendance Sheet

  • Version
  • 13'362 Downloads
  • 18 KB File Size
  • January 3, 2022 Updated
  • 0 Number of comments
  • Rating
table of content

There are school attendance sheets, meeting attendance sheets, employee attendance sheets, and many other types of attendance sheet templates, all tailored toward a specific theme. But a basic, theme-less attendance sheet can offer more flexibility. We offer a generalized monthly attendance sheet template, which can be used to record attendance for any type of program or activity. This template also comes with an automated monthly calendar.

Template Contents

Below is a list of worksheets included in this template.


A monthly attendance sheet, which includes daily attendance tracking for up to 25 attendees. This attendance sheet includes the following data fields -

  • Number
  • Name
  • Title
  • Department


A worksheet that controls how months and weekends are displayed on the “Monthly” attendance sheet.

Using the Template

General Use

Monthly Attendance Sheet

Since this is a generalized template, enter a new title that describes the monthly activity for which attendance will be recorded. In the example below, this attendance sheet will be used to record monthly “Rowing Club” practice participation.

Monthly Attendance Sheet Title

Tip: You can change the gray and white attendance sheet color scheme by changing background color and text color. A tutorial on modifying color schemes can be found here.

Enter the year in the “Year” field at the top of the worksheet. At the beginning of each month, select the current month from the dropdown menu in the “Month” field.

Monthly Attendance Sheet Month

Once the month is selected, all days of the current month will be displayed horizontally across the top of the sheet.

Note: This worksheet is built to include up to 31 days. If a month has fewer than 31 days, any extra columns will be blanked out, as shown below.

Monthly Attendance Sheet Blanked

You can change the column headings to fit the activity for which you are tracking attendance. For example, “Title” and “Department” column headings are included as standard fields in this template, but these fields may have little to do with your program or activity. Therefore, in this example, you can replace the standard column headings with fields such as “Rank” and “Weight” to record information about your rowing team.


The Setup worksheet contains a list of months and a list of weekend markers. The list of months makes up the “Month” dropdown list on the “Monthly” worksheet. The list of weekend markers indicates which days will be displayed as weekend days on the monthly attendance sheet. For example, if there is rowing practice on Saturdays or Sundays, weekends can be displayed as regular practice days on the monthly attendance sheet.

To make a weekend marker selection, use the dropdown to select “Yes” (weekend) or “No” (non-weekend).

Weekend Marker Drop Down List

A “Yes” selection is formatted in gray on the monthly attendance sheet to represent a weekend day, as shown below.

Monthly Attendance Sheet Weekend

Track Attendance

There are various ways to track attendance. For example, enter a letter such as an “X” or a “P” into the box when the person is present.

Monthly Attendance Sheet Letters Marks

Attendance can also be tracked using color codes. In the example below, green is used to indicate that the person is present, while red is used to indicate absence.

Monthly Attendance Sheet Color Marks

Number the days to indicate positive attendance and make counting total attendance a snap.

Monthly Attendance Sheet Number Marks

If you are a fan of checking the box, you can use check marks to take attendance, too! To enter a checkmark, use the “Wingdings 2” font and enter “P” into the cells.

Monthly Attendance Sheet Wingdings Marks

If there are more than 25 attendees, expand the worksheet to include as many attendees as necessary. To add more people, simply copy (Ctrl + C) the last row of the worksheet and “Insert Copied Cells” under the last row. Finally, update the attendee number and all other information.

Tip: Column headings will disappear if you scroll down toward the middle of the page. Use the “Freeze Panes” option to retain column headings. A tutorial on how to freeze panes can be found here.

New Sheets and Historical Records

If you are tracking multiple monthly meetings, create multiple attendance sheets and organize them in one file. You may also want to save and organize previous monthly attendance sheets. Create a new worksheet for each month (or new meeting theme) by duplicating the previous worksheet. This method will allow you to create historical records of previous attendance sheets. Finally, delete any old attendance records from the previous worksheet.

Tip: Create copies of attendance sheets before using them to avoid deleting old information.

A tutorial on duplicating worksheets can be found here.

How useful was this template?

Click on a star to rate it!

Average rating 4.8 / 5. Vote count: 16

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 / 62245 downloads
Shift Planner with Attendance Tracker

Weekly Attendance Sheet

14 KB / 6322 downloads
Training Attendance Sheet

13 KB / 11146 downloads
Sunday School Attendance Sheet

27 KB / 10417 downloads
Meeting Attendance Sheet

13 KB / 6808 downloads
Homeschool Attendance Sheet

16 KB / 6474 downloads
Girl Scout Attendance Sheet

16 KB / 5633 downloads
View Comments
There are currently no comments.