Monthly Employee Attendance Sheet in Excel with Auto Totals

Every small business needs a clear attendance record. This sheet shows all days of the month for each employee. You type a simple code each day and it calculates the present, absent and leave totals.

What is inside the sheet?

• 15 employees and 31 days on one page
• Simple codes: P present, A absent, L leave
• Automatic totals per employee
• Print-friendly layout

How to use it

1. Type the employee names
2. Enter the right code in each day cell
3. Review the totals at the end of the row
4. Print the sheet or keep a monthly copy

Tips for best results

• Keep the same codes so the formulas work
• Create a new copy every month
• Keep notes for special cases in a separate file

Frequently asked questions

Can I change the codes?

Yes, but edit the total formulas to match the new codes.

Does it calculate salaries?

No, it is for attendance only.

Download the sheet

Press the download button at the top of the page to get an Excel file ready to edit. The sheet is also available in Arabic from the language switcher.