Weekly Attendance Sheet

• Version
• 6'938 Downloads
• 14 KB File Size
• January 3, 2022 Updated
• 0 Number of comments
• ★★★★★

  ★★★★★
  Rating

Our “Weekly Attendance Sheet” is simple, compact, and useful as an all-purpose attendance tracker. This attendance tracker includes one worksheet with the following fields:

• Week Period
• No (Number)
• Name
• Title
• Department
• Dates (for 1 full week)

The weekly attendance tracker allows you to select “Off Day” options for days with no activity. Use this worksheet to record attendance for courses, programs, meetings, and anything else.

Using the Template

General Use

Take a moment to update the general title, “WEEKLY ATTENDANCE SHEET,” to one that better describes the activity for which you are tracking attendance. Next, set the “start day” of the week (this can be any day) for “Week Period,” as shown below.

Note: The “To” date will update automatically by adding 6 days to the “start date.”

Use the “OFF Day” dropdown to select which day(s) will be displayed as days with no attendance tracking. Options include: Saturday, Sunday, or both Saturday and Sunday.

Note: Columns containing “Off Days” and automatically formatted and displayed in gray color.

To view a how-to example, see this screen recording.

Finally, include the name, title, and department for each attendee, as shown below.

Tip: Change the gray and white attendance sheet color scheme by modifying the background and/or text colors. A tutorial on modifying color schemes can be found here.

Customize Fields

The standard fields/column headings in this attendance sheet are only suggestions. Modify them to fit your activity! For example, if you are organizing a cooking class, “Title” and “Department” may not apply, unless you are organizing this class as a work event. If the cooking class is held for the general public, consider replacing these fields with “Phone Number” and “Signature.”

The weekly attendance sheet doesn’t include a column for attendance totals. However, you can insert a new column to calculate attendance or simply overwrite one of the the “Off Day” column headings with an “Attendance Total” label, as shown below.

Tip: Use the “Merge and Center” and “Wrap Text” features under the “Home” menu to merge cells together to create more space for lengthy labels.

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. Absences can be marked with an “A” or simply left blank.

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.

Number the days to indicate positive attendance and get a total attendance count for each participant.

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

Expand Attendance Sheet

The weekly attendance sheet provides space for 38 attendees. If there are more than 38 attendees, expand the worksheet to include as many individuals 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

Tracking attendance for more than 1 week? You can create a new attendance sheet for each new week while at the same time organizing all previous weeks’ attendance sheets, all in the same file. This is done simply, by duplicating the previous worksheet. This creates an historical record of previous attendance.

A tutorial on duplicating worksheets can be found here.

Don’t forget to reset the “start day” and delete the old information to start tracking attendance.

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