Step 2 add format dates.

How to create employee attendance sheet in excel.

To make your employees more punctual and organized it is important that they arrive at the working place on time. Add company logo as well to make the sheet more reliable and dependent for the staff members of your company. This video will show you how to create a simple excel spreadsheet to record and track your employee s attendance. You have to update year and moth in the sheet. Insert the date in mm dd yy format. Employee s punctuality and productivity is dependent on timely arrival and working as planned which is ensured through employee attendance sheet template this template is also used for payroll purpose as late arrival result in deduction of salaries.

Insert the first date of the month for which you are preparing the employee attendance. Copy and paste the formula to add more employees in the template. Add the title of the sheet as attendance for month january february or whatever the month is for which you are recording this information. Do not forget to mention the year as companies are having records up to 20 years of time. You can create this attendance sheet in all version of excel and even you ca. If you want to change the format according to your needs right click the cell and choose format cell and go to the numbers tab and click on custom format.

You can also adjust your own attendance spread. Month days will be updated based on the month and year selected in the sheet. So the most important elements of this section are the name and designation of the employee. Step 1 fill in basic labels fire up excel and start by adding labels for attendance and name then use student1 for the name name slot. Attendance in ms excel can be prepared in many different formats. Step 2 in the employee details section all the essential details of the employees are mentioned.

To update the attendance and leave in the sheet select from the drop down list. The template automatically displays the date in dd mmm format. The header section of the employee attendance sheet in excel contains a large heading of the sheet title company name company logo and the month. With the student1 box selected hit ctrl enter then drag down from the bottom right corner of the box to fill in more student slots.