Weekly Attendance Sheet

  • Version
  • 350 Downloads
  • 14 KB File Size
  • May 17, 2019 Updated
  • 0 Number of comments
  • Yes Free
  • 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.”

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. Vote count:

We are sorry 🙁

Help us improve!

Holiday and Observance Calendar

37 KB / 104 downloads
Calendar Chart

61 KB / 92 downloads
Training Attendance Sheet

13 KB / 392 downloads
Sunday School Attendance Sheet

27 KB / 323 downloads
Monthly Attendance Sheet

18 KB / 455 downloads
Meeting Attendance Sheet

13 KB / 443 downloads
Homeschool Attendance Sheet

16 KB / 367 downloads
Girl Scout Attendance Sheet

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