Track Employee Attendance with Excel: Free Pre-made Sheet & Formula

Walter Jul 15, 2026

Keeping track of employee attendance is a crucial task for any organization. Excel, with its robust features and intuitive interface, is an excellent tool for creating attendance sheets. Today, we're going to guide you through creating an employee attendance sheet in Excel with a free formula. Let's dive right in!

Attendance Sheet Template in Excel
Attendance Sheet Template in Excel

Before we start, ensure you have Microsoft Excel installed on your computer. If not, you can download a free trial from the official Microsoft website. Now, let's explore the step-by-step process of creating an employee attendance sheet in Excel with a free formula.

Employee Attendance Sheet Template
Employee Attendance Sheet Template

Creating the Attendance Sheet

To get started, open a new Excel workbook and navigate to the first sheet. This will be our attendance sheet. Let's begin by setting up the header row.

Attendance Sheets for Employees - Free Templates & Printable Formats
Attendance Sheets for Employees - Free Templates & Printable Formats

Type 'Employee Name' in cell A1 and 'Date' in cell B1. These will serve as the headers for our sheet. Now, let's lock these headers in place so they remain visible even as you scroll through the data.

Autofitting Columns and Freezing Headers

the information sheet is displayed in this screenshote screen shot from www ms officegeeek com
the information sheet is displayed in this screenshote screen shot from www ms officegeeek com

To autofit columns and lock headers, follow these steps:

  1. Select cells A1 to B1.
  2. Click on the 'Home' tab from the ribbon.
  3. In the 'Cells' group, click on 'Format' then 'AutoFit Column Width'.
  4. Next, click anywhere in the range A1:B1.
  5. Go to the 'View' tab, then click on 'Freeze Panes'.
  6. Select 'Freeze Top Row'.

Adding Employee Names

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

Now, let's add employee names to our sheet. In cell A2, type the name of your first employee. Below this, in cell A3, type the name of your second employee. Continue this process until you've added all your employees' names.

As your list grows, you can make this process faster by using the 'Fill' handle. Type the first few names, then click on the small black box at the bottom-right of the cell containing the last name you've typed. Drag this box down to auto-fill the rest of the names.

Using the FREE Formula to Log Attendance

Employee Attendance Calendar 1728
Employee Attendance Calendar 1728

The real power of an Excel attendance sheet lies in its ability to automatically log attendance. Here, we'll use a free formula to achieve this. Let's explore this in detail.

The formula we'll use is a simple combination of IF and COUNT functions. But first, let's prepare our date columns.

Employee Absence Schedule Template for Excel | Download
Employee Absence Schedule Template for Excel | Download
2021 Employee Attendance Calendar Excel
2021 Employee Attendance Calendar Excel
“Weekly Attendance Tracker – HR Excel Dashboard Template”
“Weekly Attendance Tracker – HR Excel Dashboard Template”
“Weekly Attendance Tracker – HR Excel Dashboard Template”
“Weekly Attendance Tracker – HR Excel Dashboard Template”
Printable Minimalist Black and White Employee Attendance Sheet Template
Printable Minimalist Black and White Employee Attendance Sheet Template
🔥🔥 Fully Automated Attendance Sheet in Excel
🔥🔥 Fully Automated Attendance Sheet in Excel
Download Employee Attendance Sheet Excel Template - ExcelDataPro
Download Employee Attendance Sheet Excel Template - ExcelDataPro
Redirecting...
Redirecting...
Fully Automatic Advance Attendance sheet in Excel
Fully Automatic Advance Attendance sheet in Excel

Setting Up Date Columns

In each cell of column B, starting from B2, type the dates for the month you want to track. For example, if you want to track attendance for January, type '1-Jan' in B2, '2-Jan' in B3, and so on.

To make this faster, you can use the 'AutoFill' feature. Type the first few dates, then click on the fill handle at the bottom-right of the cell containing the last date you've typed. Drag this box down to auto-fill the rest of the dates.

Using the FREE Formula

Now, let's add the formula to log attendance. In cell C2, type the following formula:

=IF(COUNTIF($A$2:$A$100,A2), "P", "Absent")

This formula checks if the employee's name in column A exists in the range of dates in column B. If it does, it marks attendance as 'P' (for Present). If not, it marks attendance as 'Absent'.

Drag this formula down to apply it to the rest of the attendance sheet. That's it! Your free formula is now logging your employees' attendance in real-time.

Regularly update the dates and employee names as needed. Soon, you'll have a comprehensive record of your employees' attendance for the entire month. Keep in mind to update the range in the formula whenever you add new employees or dates.

Remember, consistency is key when it comes to attendance tracking. Regularly updating your Excel attendance sheet ensures a reliable record that can help in scheduling, leave management, and more.

With this guide, you now have an easy, free, and efficient way to track employee attendance using Excel. So, get started on creating and maintaining your attendance sheet today! And as your organization grows, consider exploring advanced tools and features in Excel to streamline your attendance tracking process.