

And all the employee attendance information will reveal automatically.

In this worksheet, all you have to do just fill the ID of the employee and your targeted year. You can enlarge a picture one year attendance worksheet above to see it clearly. This excel file consist of one worksheet of one year attendance worksheet, 12 worksheets of monthly attendance, one worksheet of holiday and one worksheet of employee data. Perhaps this excel file is a combination between monthly and yearly attendance record where you can use some worksheets of this template as a printable monthly attendance forms and collect all monthly data to form employee attendance record for one year period.
