Employee Attendance Sheet in Excel with Formulas Download


Employee Attendance Sheet in Excel with Formulas Download


Employee attedance management is one of the most crucial tasks for HR department in any organiztion. A good attedance sheet will make this work easy. Here you can download a simple employee attedance sheet in excel with formulas, which calculate details automatically.

By using this excel template you can easily calculate the number of paid days, LOPs, closing balance of various leaves such casual leaves (CL), sick Leaves (SL),earned leaves (EL) and other leaves (OL) etc.

How to Use this Attendance Sheet

This attendance sheet doesn’t has any protection like passwords, so you can make any modifications which you want like adding company name and address etc.

  1. You just need to select the month and enter the year, then the no of days will be automatically visible to you.
  2. You can add as many as a number of employees.
  3. You can copy the formulas in additional cells if the number of employees increases.
  4. Every month you have to upload the opening leave balance of the employees (or) you can just copy the closing leave balance and paste it in next month’s attendance sheet as opening leave balance.
  5. This sheet has a proper page set up so you won’t face any problems while taking printouts of the attendance sheets.

How to Create Employee Attendance Sheet in Excel

  1. You can create your own employee attendance excel by inputting basic data of employees like their name and id.
  2. Now add month and year for which period you want to make the attendance sheet, every month you have to change these details.
  3. Now format the dates and mark the holidays.
  4. Now update the opening leave balance of the employees.
  5. Finally mark the attendance of the employees. (You can use formulas present in the above excel sheet to prepare your own attendance sheet format.)

Also read


Jaspreet Singh Ghuman

Jaspreet Singh Ghuman


Passionate Professional Blogger, Freelancer, WordPress Enthusiast, Digital Marketer, Web Developer, Server Operator, Networking Expert. Empowering online presence with diverse skills.

jassweb logo

Jassweb always keeps its services up-to-date with the latest trends in the market, providing its customers all over the world with high-end and easily extensible internet, intranet, and extranet products.


Jassweb, Rai Chak, Punjab, India. 143518
Item added to cart.
0 items - 0.00