We want our template to have a few rows for each working time. To assign the day of the week to the dates we have, do the following:Īpply the following function to the B3 cell: =TEXT(B2, "DDDD")ĭrag the cell towards the right to H3 – you’ll get the days of the week for each consequent date. Next, select the C2 cell and apply the following formula: =B2+1ĭrag the cell towards the right to H2 – the cells will be filled with consequent dates. Now, when you double-click on the B2 cell, a calendar will drop down for you to pick the date as the starting day of the week. Then pick Date in the Criteria field and click on Save. For this, right-click on the cell and select Data Validation. Apply Data Validation to the cell with the starting date – this is B2 on our template. Hence, let’s make the template time-flexible. Others may have a different starting day of the week. Most businesses start their work week on Mondays. If you wish, you can explore a ready-to-use weekly schedule template. For that reason, let’s make a custom reusable schedule template. If you need to input several tasks for a particular time, you’ll need to manually insert as many rows as needed. For example, it only provides one row for each time. The default Google Sheets weekly schedule template is good, but it can and should be improved. Weekly schedule template in Google Sheets: do it yourself
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |