Staff Attendance Sheet Excel Template with Formula Free Download

Walter Jul 15, 2026

Keeping track of staff attendance is a crucial task for any organization, and Excel provides a simple yet powerful tool to manage this efficiently. A well-designed staff attendance sheet in Excel not only records present and absent employees but also allows for data analysis and reporting. In this guide, we'll walk you through creating a staff attendance sheet using Excel, along with a useful formula to calculate attendance percentages.

Attendance Sheet Template in Excel
Attendance Sheet Template in Excel

Before we dive into the details, let's ensure you're using a compatible version of Excel. The methods and formulas mentioned in this guide are suitable for Excel 2010 and later versions, including Microsoft 365.

the printable attendance sheet is shown in black and white
the printable attendance sheet is shown in black and white

Setting Up the Staff Attendance Sheet

First, let's set up the basic structure of the staff attendance sheet. Open a new or existing Excel workbook and click on the 'Sheet1' tab at the bottom to rename it as 'Attendance'.

Simple Staff Attendance Sheet
Simple Staff Attendance Sheet

Now, let's create headers for our sheet in Row 1 (A1:M1). Here's a suggested layout:

  • Name
  • Designation
  • Date
  • D1 (e.g., 01-Jan)
  • D2
  • D3
  • ...
  • D31
  • Total Days
  • Present Days
  • Absent Days
  • Attendance %
Student Attendance Record Template For Excel
Student Attendance Record Template For Excel

Formatting Dates and Attendance Columns

To ensure our attendance sheet stays tidy and organized, let's format some columns.

1. Freeze the header row: Click on the 'View' tab, then 'Freeze Panes', and select 'Freeze Top Row'.

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

2. Format dates: Select the date columns (B2:M2), right-click, and choose 'Format Cells' -> 'Number' -> 'Custom'. Enter 'mmm-yy' in the 'Type' field, then click 'OK'.

3. Format attendance percentages: Select the 'Attendance %' column (N2:N), right-click, and choose 'Format Cells' -> 'Number' -> 'Percentage'. Click 'OK'.

Entering Staff Data

Printable Minimalist Black and White Employee Attendance Sheet Template
Printable Minimalist Black and White Employee Attendance Sheet Template

Start entering staff data from Row 2. In the 'Name' column (A2), input staff names. In the 'Designation' column (B2), input their respective designations.

For each date column (C2:M2), enter 'P' for present and 'A' for absent. Alternatively, you can use a '1' for present and a blank cell for absent.

Employee Attendance Calendar 1728
Employee Attendance Calendar 1728
“Weekly Attendance Tracker – HR Excel Dashboard Template”
“Weekly Attendance Tracker – HR Excel Dashboard Template”
江苏篮球队 - 2026赛季激战正酣,解锁观赛新体验
江苏篮球队 - 2026赛季激战正酣,解锁观赛新体验
🔥🔥 Fully Automated Attendance Sheet in Excel
🔥🔥 Fully Automated Attendance Sheet in Excel
“Weekly Attendance Tracker – HR Excel Dashboard Template”
“Weekly Attendance Tracker – HR Excel Dashboard Template”
2021 Employee Attendance Calendar Excel
2021 Employee Attendance Calendar Excel
Attendance Sheet Templates - Excel Word Template
Attendance Sheet Templates - Excel Word Template
Attendance Sheets for Employees - Free Templates & Printable Formats
Attendance Sheets for Employees - Free Templates & Printable Formats
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet
Staff Time Tracker Excel Template | Employee Attendance & Overtime Sheet

Calculating Attendance

Now that we have our staff attendance data, let's calculate the total days, present days, and attendance percentages using Excel's built-in functions.

Here are the formulas for each column:

Column Formula
Total Days =COUNTA($D$1:D2)
Present Days =COUNTIF($C$2:M2, "P")
Absent Days =IF(ERROR.TEXT(COUNTA($C$2:M2)-COUNTIF($C$2:M2, "P")), COUNTA($C$2:M2)-COUNTIF($C$2:M2, "P"))
Attendance % =IFERROR(IF(ISBLANK(F2), "NA", (F2/G2)*100), 0)

Dragging Formulas Down

Now, drag these formulas down to apply them to all staff members. To do this, click and drag the small square in the bottom-right corner of the cell containing the formula down to the last row of your staff data.

Your staff attendance sheet is now complete! You can sort, filter, and analyze the data as needed. Additionally, you can add charts or pivot tables for better visualization and reporting.

automating the Sheet with VBA (Optional)

To save time and ensure accuracy, you can automate your attendance sheet using VBA (Visual Basic for Applications). This involves creating a VBA script that populates attendance data based on specific criteria. For a detailed guide on this, consider exploring external resources or consulting an Excel expert.

With your staff attendance sheet set up and functional, you're now well-equipped to manage and monitor employee attendance seamlessly. By utilizing Excel's powerful features and following our step-by-step guide, you've created a valuable tool for both tracking attendance and analyzing workforce performance. As your organizational needs grow, consider expanding your sheet with additional features and functionalities.