Employee Attendance Sheet for Excel with Formula | Download PDF

Walter Jul 15, 2026

Streamlining employee attendance tracking is a critical aspect of efficient workforce management. Excel, with its powerful formula capabilities, is an excellent tool for creating attendance sheets. Here, we'll guide you through creating an employee attendance sheet in Excel, assisted by formulas, and provide a PDF download for your convenience.

Attendance Sheet Template in Excel
Attendance Sheet Template in Excel

This guide caters to human resource personnel, managers, and business owners seeking a reliable, automated method for recording and analyzing employee attendance data.

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

Setting Up the Excel Attendance Sheet

Starting with a clean template, we'll adapt it to serve as an employee attendance sheet.

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

First, label columns A to E as follows: 'Employee ID', 'Full Name', 'Date', 'Status', and 'Reason (if absent/late)'.

Automatic Date Generation

2021 Employee Attendance Calendar Excel
2021 Employee Attendance Calendar Excel

To automatically generate dates, use the 'Date' function in Excel. In cell A1, type `=DATE(YYYY,MONTH(),DAY())` and drag it across for the required number of days. This will populate the 'Date' column with consecutive dates.

For example, typing `=DATE(2023,3,1)` in cell A1 will display '1-Mar-23' in the cell, and dragging it across will generate subsequent dates.

Employee Data Entry

Employee Absence Schedule Template for Excel | Download
Employee Absence Schedule Template for Excel | Download

Enter employee data in the 'Employee ID' and 'Full Name' columns. You can use the 'AutoFill' feature by dragging the fill handle to add more entries.

Use the 'Data Validation' tool in Excel to ensure data entered in these columns adheres to the required format (e.g., numeric for 'Employee ID' and text for 'Full Name').

Implementing Attendance Tracking Formulas

“Weekly Attendance Tracker – HR Excel Dashboard Template”
“Weekly Attendance Tracker – HR Excel Dashboard Template”

Next, we'll introduce formulas to track and analyze employee attendance data.

Tracking Daily Attendance

“Weekly Attendance Tracker – HR Excel Dashboard Template”
“Weekly Attendance Tracker – HR Excel Dashboard Template”
Fully Automatic Advance Attendance sheet in Excel
Fully Automatic Advance Attendance sheet in Excel
Download Employee Attendance Sheet Excel Template - MSOfficeGeek
Download Employee Attendance Sheet Excel Template - MSOfficeGeek
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
🔥🔥 Fully Automated Attendance Sheet in Excel
🔥🔥 Fully Automated Attendance Sheet in Excel
Redirecting...
Redirecting...
Ultimate Employee Attendance Tracker Excel Template 2025
Ultimate Employee Attendance Tracker Excel Template 2025
data entry
data entry
Employee Attendance Sheet Excel & Word
Employee Attendance Sheet Excel & Word

In the 'Status' column (D), use the 'IF' function to track if an employee is present (P), absent (A), or late (L). In cell D2, enter the formula: `=IF(E2="","",IF(C2

Calculating Late Attendance

To mark an employee as 'L' (late), you can modify the 'IF' function in the 'Status' formula to include a time check. In cell D2, update the formula to: `=IF(E2="","",IF(OR(C2

Analyzing Attendance Data

To analyze attendance data, calculate the number of present, absent, and late days for each employee.

Present Days

In a new sheet, use the 'COUNTIFS' function to count the number of 'P' instances for each employee. In cell A2, type `=COUNTIFS(Sheet1!$D:$D,"P",Sheet1!$A:$A,$A$1)` and drag it down, where 'Sheet1' is the name of your attendance sheet, and 'A' is the 'Employee ID' column.

Absent and Late Days

Similarly, calculate 'A' and 'L' days using the 'COUNTIFS' function and sum them up with the 'Present Days' count to get the total working days.

Now you have a comprehensive Excel attendance sheet that tracks, analyzes, and displays employee attendance data efficiently.

To download the PDF, click the link below and follow the prompts to convert your Excel sheet into a PDF format for easy sharing and printing. Download Employee Attendance Sheet

Regularly review and update your attendance sheet to ensure accurate records and make informed decisions about workforce management. Embrace the power of Excel formulas to streamline tracking and analysis for enhanced productivity.