The orange filled cells in this table are for you to input the correct information, whilst the light grey filled cells are calculated. Details of how to create and modify the named range of cells is in the second part of this article. The list of bank holidays is a named range (group of cells) and this name is used in the calculations of working days. It is simply a list of dates and may be over typed if these are not appropriate for your company. This list of bank holidays is taken from and represents English and Welsh bank holidays as current at May 2012. A table for calculating holiday allowance for part time employees.List of bank holiday dates 2012 to 2015 for use in calculating working days between two dates.The Reference sheet contains two sets of information: Employee SheetsĮach employee sheet works in the same way and is used as shown below. Repeat this process until you have sufficient sheets for your employees and they have been added to the Summary tableĪn exact replica of the employee sheets, but named Template for use in creating extra employees.Remember that the name must be the same in both the Summary table and on the sheet tab, including capitalisation and punctuation The newly created record can be summarised by adding the employee name to the Summary sheet (as described above).Right click on the Template(2) sheet tab and choose Rename from the sheet tab menu.Figure 4 below shows that the new sheet will be positioned before the Reference sheet and as a duplicate of Template The new sheet can be positioned as you choose, but should be before Reference.

F2 calculation using excel sheet