↓ Free Download Excel Attendance Sheet ↓

↓ Free Download Excel Attendance Sheet Template 2026 ↓

Features: Auto Present/Absent Count, Auto % Calculation, Monthly + Daily Format. Just Enter P, A, L

check the screeshot below to see how the sheet work. Simply type P, A,or L and th reset will b auto calculated.

Free Excel Attendance Sheet Template 2026 with Formula - Download .xlsx

Assalam u Alaikum friends!

If you are looking for an easy way to manage attendance, Microsoft Excel can be a very useful option. Wheather you need an employee attendance sheet, a student register, or a simple monthly record, Excel lets you organize everything in the place.

In this guide, we will learn how to create an attendance sheet in Excel, use simple formulas, calculate attendance percentages, and make a practical spreadsheet that can be reused every month.

What Is an Excel Attendance Sheet?

An Excel attendance sheet is a spreadsheet used to record whether employees, students, teachers, or workers are presents or absent on particular days.

You can use simple codes such as P for Present, A for Absent, and L for Leave.

Employee Name	1	2	3	4	5	Present	Absent
Ali	P	P	A	P	P	4	1
Ahmed	P	A	P	P	P	4	1
Sara	P	P	P	P	A	4	1

This basic attendance sheet format in Excel can easily be changed according to your needs.

Example of a simple employee attendance sheet created in Microsoft Excel.

How to Create Employee Attendance Sheet in Excel

Creating a new Excel sheet for atendence is quite simple. Open Microsoft Excel and start with a blank workbook.

First, decide what information you want too record. A basic employee attendance sheet in Excel may include:

Employee ID
Employee Name
Department
Date
Attendance Status
Check-in Time
Check-out Time
Working Hours
Remarks

For a monthly register, you can place employee names on the left and the days of the month across the top.

Employee Name	1	2	3	4	5	6	7	Total
Ali	P	P	A	P	P	P	A	5
Ahmed	P	P	P	P	A	P	P	6
Sara	A	P	P	P	P	A	P	5

Once the basic layout is ready, you can add formulas and formatting to make the sheet easier to use.

Creating a monthly attendance register with employee names and daily dates in Excel.

Attendance Sheet in Excel With Formula

One of the biggest advantages of Excel is that you don't have to count everything manually.

For example, if the attendance information is entered from B2 to AF2, you can count the number of Present days with this formula:

=COUNTIF(B2:AF2,"P")

To count absent days, use:

=COUNTIF(B2:AF2,"A")

You can also calculate the attendance percentage.

Present Days ÷ Working Days × 100

If an employee attende 25 out of 26 working days:

25 ÷ 26 × 100 = 96.15%

Using an attendance sheet in Excel with formula makes a large attendance spreadsheet much easier to manage.

Using Excel formulas to automatically calculate present and absent days.

Employee Attendance Sheet in Excel

Businesses can use an employee attendance register to keep track of daily staff attendance.

A more detailed sheet can include check-in and check-out times:

Date	Employee	Status	Check In	Check Out	Working Hours
03-Sep	Ali	Present	09:00 AM	05:00 PM	8
03-Sep	Ahmed	Late	09:20 AM	05:00 PM	7.67
03-Sep	Sara	Absent	—	—	0

This type of attendance sheet for work can be useful for small offices, shops, schools, and businesses.

If you also prepare salaries in Excel, attendence informations can be used alongside a salary sheet in Excel to help calculate working days and unpaid absences.

An employee attendance spreadsheet can include working hours and daily attendance information.

Staff Attendance Sheet

A staff attendance sheet is use full for organizations that have several employees or workers.

You can create a seperate worksheet for every month or maintain the whole year inside one Excel workbook.

For example, your workbook could contain:

January Attendance
February Attendance
March Attendance
April Attendance
Monthly Summary

This makes it easier to find old attendance records without creating a completely new file every time.

For small businesses, A simple staff attendance register may be enough. Larger organizations that need biometric integration, automatic notifications, or advanced reporting may prefer dedicated attendance management software.

A staff attendance workbook can contain separate monthly sheets and an annual summary.

Student Attendance Register in Excel

Excel isn't only useful for offices. Teachers can also create a student attendance register for their classes.

A teacher can enter the name of students in the first column and the class dates across the top.

Student Name	1	2	3	4	5	Present	Absent
Hassan	P	P	A	P	P	4	1
Usman	P	A	P	P	P	4	1
Ayesha	P	P	P	A	P	4	1

At the end of the month, the teacher can check each student's total attendance and calculate their percentage.

This is a simple and practical way to maintain an attendance register for students throughout the academic year.

Teachers can use excel to maintain a simple student attendance register.

Daily Attendance Register

Sometimes you don't need a large monthly table. A daily attendance register can be more convenient when attendance is recorded throughout the day.

Date	Name	Status	In Time	Out Time	Remarks
03-Sep-2026	Ali	Present	9:00 AM	5:00 PM	On Time
03-Sep-2026	Ahmed	Late	9:25 AM	5:00 PM	Late
03-Sep-2026	Sara	Absent	—	—	Leave

You can use this attendance sheet format for employees, workers, teachers, or students.

A daily attendance register records attendance and working times for each day.

Monthly Attendance Sheet in Excel

If you regularly prepare attendance records, creating a reusable monthly attendance sheet can save you a lot of time.

Once your template is ready, you can simply copy it for the next month and update the dates.

A useful template can contain:

Employee names
Daily attendence
Present days
Absent days
Leave days
Working days
Attendance percentage
Monthly summary

People searching for a monthly attendance sheet Excel free download can also find ready-made templates, but it is always a good idea to check the formulas before using a downloaded spreadsheet for important records.

A monthly attendance template makes it easier to maintain employee records throughout the month.

Excel Spreadsheet for Practice

If you are learning Excel, creating an attendance registers is actually a good Excel spreadsheet for practice.

Instead of practicing with random numbers, you can create a realistic attendance file and learn different Excel features while working on it.

You can practice:

Data entry
Cell formatting
Tables
COUNTIF formulas
Percentages
Sorting
Filtering
Conditional formatting
Charts

This type of Excel practice worksheet can help beginners become more comfortable with spreadsheets.

An attendence worksheet can b a useful Excel practice project for beginners.

Attendance Chart in Excel

Once you have enough attendance date, you can create an attendance chart to make the information easier to understand.

For example, a chart can show:

Total Present days
Total Absent days
Leave days
Attendance percentage
Monthly attendance trends

Charts can be particularly useful when you are dealing with a large Excel spreadsheet because they make important information easier to see at a glance.

Excel charts can turn attendance records into an easy-to-read visual summary.

Excel Spreadsheet Online and Google Sheets

Today, many people work with spreadsheets online instead of keeping everything on their computer.

Google Sheets can be used to create an online spreadsheet, and Excel files can also be moved between Microsoft Excel and Google Sheets.

For example, you may need Excel to Google Sheets conversion when you want to share a spreadsheet with other people and work on it online.

Similarly, a Google spreadsheet can be downloaded as an Excel file when you need to continue working with Microsoft Excel.

This is why terms such as Google spreadsheet to Excel, Google Excel sheet, Google online spreadsheet, and Google Sheets to Excel are commonly searched by spreadsheet users.

Microsoft Excel and Google Sheets can both be used for online spreadsheet and attendance tasks.

Other Useful Excel Spreadsheet Examples

Once you learn how to create an attendance spreadsheet, you can use the same skills for many other types of work.

Some common examples include:

Balance sheet template Excel
Salary sheet in Excel
Excel accounting spreadsheet
Expense sheets
Marks sheet Excel
Habit tracker spreadsheet
Working-hours tracker
Inventory spreadsheet
Sales report
Employee register

These projects are also useful if you are practicing Excel for office work or data entry.

Excel can be used for attendance, accounting, salary, expenses, marks and many other spreadsheet tasks.

Final Thoughts

Creating an attendance sheet in Excel is much easier than it may seem. You can begin with a blank Excel sheet, add employee or student names, enter the dates, and mark attendance using simple codes such as P, A, and L.

After that, you can add formulas to automatically count attendance and calculate percentages. If you want a more detailed system, you can include working hours, check-in times, leave records, and monthly summaries.

Whether you need an employee attendance sheet, staff attendance sheet, student attendance register, or monthly attendance sheet in Excel with formula, Excel gives you plenty of flexibility.

And if you are still learning, don't worry about making a complicated spreadsheet at the beginning. Start with a simple Excel spreadsheet for practice, learn a few formulas, and improve your sheet step by step. That is usually the easiest way to become comfortable with Excel.

Free Excel Attendance Sheet Template 2026 with Formula - Download .xlsx File