Excel Daily Attendance Sheet with Formula: Free Download

Walter Jul 15, 2026

Streamlining your daily operations with an efficient attendance tracking system is vital for any organization. An Excel-based daily attendance sheet is a tried-and-true method that combines the simplicity of pen and paper with the power of digital data management. In this article, we'll guide you through creating an interactive Excel attendance sheet using formulas, enhancing your daily tracking process. Plus, we'll provide a download link for a ready-to-use template.

Attendance Sheet Template in Excel
Attendance Sheet Template in Excel

Before we dive in, ensure you have a basic understanding of Excel and its formulas. We'll be using the TODO function, COUNTIF function, and some autocorrection tricks to make our sheet fully functional. Let's break down this process into digestible sections.

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

First, let's set up the basic structure of your sheet. You'll need three main sections: an input area for employee information, an output area for attendance data, and a summary area for total attendances.

Fully Automatic Advance Attendance sheet in Excel
Fully Automatic Advance Attendance sheet in Excel

For our example, let's assume you have 10 employees with the data: Employee ID (A1:A10), Employee Name (B1:B10), and Department (C1:C10).

Implementing an Attendance Input Area

Employee Attendance Tracker | Free Excel Attendance Spread | Updated for 2026 | Leave Board
Employee Attendance Tracker | Free Excel Attendance Spread | Updated for 2026 | Leave Board

Create a new column for dates (D1:D11, starting from today and ending 10 days from now). Then, add headers for Present (E1), Late (F1), and Absent (G1). Freeze the top row (View → Freeze Panes → Freeze Top Row) for easy navigating.

To mark attendance, simply input P for Present, L for Late, and a blank cell for Absent. Use Excel's Data Validation feature to restrict inputs to these three options (Data → Data Validation → Settings → List → P, L).

Automatically Filling Dates

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

To save time, automate filling dates. In cell D2, use the formula =TODAY() (hit Enter). Then, select D2 and drag down to D11 to fill the dates. To adjust future dates, simply edit cell D2 and the range will update.

Calculating Attendance Data

Now, let's calculate total present, late, and absent days for each employee using Excel's COUNTIF function.

🔥🔥 Fully Automated Attendance Sheet in Excel
🔥🔥 Fully Automated Attendance Sheet in Excel

Present Days

In cell H2, enter the formula =COUNTIF($E$2:$E$11, "P") and drag it down to H11. This formula counts all Ps in column E from rows 2 to 11.

2021 Employee Attendance Calendar Excel
2021 Employee Attendance Calendar Excel
Daily Attendance Report Template - Free Report Templates
Daily Attendance Report Template - Free Report Templates
Employee Attendance Calendar 1728
Employee Attendance Calendar 1728
Attendance Tracker in Excel
Attendance Tracker 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
Easy Attendance Sheet Tutorial
Easy Attendance Sheet Tutorial
FREE Attendance Sheet Template | Word, PDF, Excel & Image
FREE Attendance Sheet Template | Word, PDF, Excel & Image
Advance ATTENDANCE SHEET in Excel \
Advance ATTENDANCE SHEET in Excel \
Fully Automatic Attendance sheet  With Salary sheet in excel by learning Center in Urdu/hindi
Fully Automatic Attendance sheet With Salary sheet in excel by learning Center in Urdu/hindi

To get the total present days for all employees, use =SUM(H2:H11) in cell H12.

Late Days

Repeat the above process for Late days in columns I and J, and use =SUM(I2:I11) in cell J12 for total late days.

Absent Days

To find absent days, subtract total present and late days from the total working days (10, in this case). In cell K2, enter =10 - J2 and drag it down to K11. Then, calculate the total absent days with =SUM(K2:K11) in cell K12.

Your interactive attendance sheet is now complete! You can update it daily and track attendance data effortlessly.

Downloading a Pre-built Attendance Sheet

If you want to skip the setup process, you can use our pre-built template. Click here to download our Excel attendance sheet template. Customize it to fit your needs before using.

Using a well-structured daily attendance sheet boosts your administrative efficiency. With this Excel-based tool, you can streamline your attendance tracking, reduce manual errors, and gain better insights into your team's work patterns. Start using this practical solution today and revolutionize your daily operations.