We made an Excel template, to calculate the days that the workers of a company have worked and the holidays made.
The template contains 13 sheets: a monthly sheet, where the days worked and holidays are noted in calendar format, and another sheet, which is for consolidation, where the totals of each monthly sheet are calculated and the annual results are presented.
Up to 14 different types of incidents are established on each sheet, in order to catalogue the different holidays that a worker can take, or those of sick leave, or those of holidays, etc.
The example presents a table in which the names of the workers and the days of the month are arranged. Inside the table, the holidays that each worker takes, according to the legend, are entered by hand. Outside the table, another table is created with the list of workers and the types of public holidays and working days. In the correspondence of each value, ther are the formulas that count the days and make totals. We show some pictures.
Image of a monthly sheet:
Picture of the totals sheet:
Application made with Excel. To use this application you need to have the MS Excel program. The application is made in Spanish language. Note: The data inserted in the images are fictitious.