Additional featuresĬonditional formatting has been used throughout the spreadsheet to highlight weekends. For example, when adding a new Week 6 worksheet, the formula in cell D3 would need to be modified to say ='Week 5'!D3+7 so that Excel knows where to get the date from.

The only part that needs to be changed here is the week number, as this is calculated based on the previous week's worksheet. Once the new sheet has been created, you will need to alter the formula in cell D3 slightly, in order to display the correct date. Rename the sheet to the correct week number by double clicking on the tab name, and altering the text. To add a new sheet to the end, highlight the last sheet and make sure the Create a copy box is ticked before clicking OK. Week 5) and from the menu, select Move or Copy. Right click on the tab for the last week (e.g. If you want to add more than 5 weeks at a time, it is a quick and easy process to add them in. The weekly schedule spreadsheet comes with the first 5 weeks ready to go. Covering a 12-hour period, there is plenty of space for you to enter any meetings, classes or appointments you need to attend, or for planning your workload. The weekly schedule has a timeline split into 15 minute slots, which is ideal for recording short appointments or micromanaging your day.

Weekly work schedule templates