Weekly Attendance Sheet

  • Version
  • 6'222 Downloads
  • 14 KB File Size
  • January 3, 2022 Updated
  • 0 Number of comments
  • Rating
table of content

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.”

Weekly Attendance Sheet 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.

Weekly Attendance Sheet Off Day

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

Weekly Attendance Sheet Attendee Information

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.”

Weekly Attendance Sheet Customize Fields

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.

Weekly Attendance Sheet Total

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.

Weekly Attendance Sheet Merge and Wrap

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.

Weekly Attendance Sheet Track Letters

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.

Weekly Attendance Sheet Track Colors

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

Weekly Attendance Sheet Track Numbers

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.

Weekly Attendance Sheet Track Wingdings

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.

How useful was this template?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 5

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

Training Attendance Sheet

13 KB / 10881 downloads
Sunday School Attendance Sheet

27 KB / 10253 downloads
Monthly Attendance Sheet

18 KB / 13131 downloads
Meeting Attendance Sheet

13 KB / 6617 downloads
Homeschool Attendance Sheet

16 KB / 6378 downloads
Girl Scout Attendance Sheet

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