Daily Attendance Sheet in Excel with Formula Template (Free Download)

Walter Jul 15, 2026

Keeping track of daily attendance can be a daunting task, especially for larger classrooms or organizations. Excel, with its powerful features, offers a practical solution. By creating a daily attendance sheet with formulas, you can automate tracking and save time. Here, you'll find a free downloadable template with step-by-step guidance on how to set it up.

Attendance Sheet Template in Excel
Attendance Sheet Template in Excel

Excel's flexibility and robust features allow you to customize your attendance tracker to fit your specific needs. Whether you're a teacher, HR manager, or event organizer, you can create a user-friendly and efficient daily attendance sheet.

the attendance list is shown in this printable sheet for students to practice their work
the attendance list is shown in this printable sheet for students to practice their work

Setting Up Your Excel Daily Attendance Template

Before diving into the formulas, let's first set up the basic structure of your attendance sheet.

Daily Attendance Report Template - Free Report Templates
Daily Attendance Report Template - Free Report Templates

1. **Columns**: Include columns for Date, Name, and Attendance Status (Present, Absent, Late). You can add more columns for other details like Sign-in/out time, Reason for Absence, etc.

Creating the Date Column

2021 Employee Attendance Calendar Excel
2021 Employee Attendance Calendar Excel

In the first row, type "Date" in the first cell (A1). Then, drag the fill handle (small square in the bottom right corner of the cell) to copy this header for all dates you want to track.

To format these cells as dates, select them, right-click, and choose "Format Cells". Under Number, select "Custom", and enter the date format you prefer (e.g., MM/DD/YYYY or DD-MM-YYYY).

Populating the Names Column

name list
name list

Start by typing the names in the cells below, or use Excel's Flash Fill feature for populate from a neighboring range, saving you time and reducing errors.

To use Flash Fill, type a few names in the first row, then click anywhere else in the column. In the "Data" tab, click "Flash Fill" to populate the rest of the names.

Adding Formulas for Attendance Tracking

Employee Attendance Calendar 1728
Employee Attendance Calendar 1728

Now that you've set up the basic structure, it's time to add formulas that automatically track and calculate attendance data.

Using the COUNTIF Function

Printable Minimalist Black and White Employee Attendance Sheet Template
Printable Minimalist Black and White Employee Attendance Sheet Template
a spreadsheet with the numbers and times for each employee to use on their work schedule
a spreadsheet with the numbers and times for each employee to use on their work schedule
🔥🔥 Fully Automated Attendance Sheet in Excel
🔥🔥 Fully Automated Attendance Sheet in Excel
Attendance Tracker in Excel
Attendance Tracker in Excel
Excel Monthly Attendance Sheet
Excel Monthly Attendance Sheet
the daily attendance sheet for students
the daily attendance sheet for students
Attendance Sheets for Employees - Free Templates & Printable Formats
Attendance Sheets for Employees - Free Templates & Printable Formats
Advance ATTENDANCE SHEET in Excel \
Advance ATTENDANCE SHEET in Excel \
Daily Attendance Sheet Template in Pages, Apple Numbers, Word, Google Docs, Excel, Google Sheets - Download | Template.net
Daily Attendance Sheet Template in Pages, Apple Numbers, Word, Google Docs, Excel, Google Sheets - Download | Template.net

The COUNTIF function is an essential tool for tracking attendance. It counts the number of cells in a range that meet a specific criterion.

To count the number of present employees/users each day, use the formula in a new column: `=COUNTIF(B2:B100,"Present")`, replacing the range (B2:B100) with the range of your data.

Calculating Total and Absenteeism

To calculate the total count and absentees, use the SUM function (for total) and COUNTIF with the criterion "Absent" (for absentees).

For example, in a new row at the bottom, use `=SUM(B2:B100)` to get the total count, and `=COUNTIF(B2:B100,"Absent")` to get the number of absentees.

**Pro tip**: Format these summary cells as percentages to show absenteeism rate. To do this, select the cells, right-click, and choose "Format Cells". Under Number, select "Percentage" and adjust the decimal places as desired.

Remember, it's crucial to update the range in your formulas as you add more data. To do this efficiently, use Excel's structured references, which let you reference entire tables or lists.

Now that you have your free, automated daily attendance template, you'll save time and reduce errors. Keep it up-to-date, and use it to gain valuable insights into attendance patterns.