4/30/2024 0 Comments Task planner template excelThis process can be repeated to print off planners for other pairs of days on the date picker. Enter an x in the white box to the left of the pair of dates you want to print daily planners for, and then print the page. The Date Picker allows you to choose dates within a range approximately one month of the start date entered on the Settings worksheet. The Daily Planner is designed to be printed on double sided A4, with a day on each side of the page. You can enter anything you like in the description, so the page can be used for recording anything from birthdays through to a reminder that your car insurance is due for renewal.Īny events entered in the Special Events worksheet will appear on the Things To Remember section of the Daily Planner when the relevant date has been selected. There is no need to enter the date in Column A, as this will be worked out by entering the day and month. The Special Events worksheet works in much the same way as the holidays worksheet. You may find some useful information in the additional resources section below. These can simply be added by inputting the day and month of the holiday.Ī number of holidays have already been filled in, however there are many resources online providing detailed information on when they fall. The third section is for holidays which occur on the same day every year, for example Christmas Day. The references worksheet has a list of websites which contain some helpful formulas. It can be quite complicated to work out when these holidays occur, so it will be necessary to create or find an appropriate formula. The second section is for holidays where the date changes every year, for example Easter Sunday. The day number assumes Sunday is day 1, Monday day 2 etc. These can be entered by putting in the month, week and day number in which the events occur. The first section is for holidays which occur on a specific day of the week in any given year, for example, the UK May Day Bank Holiday which always occurs on the first Monday in May. It is advisable to not manually enter any dates in the Date column, shown in blue, as this column will automatically calculate the next occurrence of a holiday based on the information entered in the day, month and week day columns where applicable. For all of these, the description of the holiday can be anything you like, and the country can either be entered, or left blank if it is a holiday to be used across all countries. The Holidays worksheet is split into three sections. HolidaysĮntering a holiday will cause the description of the holiday to show up in red below the date on the Daily Planner. It will not do anything unless you also enter a corresponding holiday into the holidays worksheet. If you are not using the calendar for any of the countries for which holidays are already listed, you can add your country to the Countries list below the General Settings, which will enable you to pick it from the Select Country drop-down menu. Here you can select the Start Date for the Date Picker, the Week Start Date for the mini calendars, the Currency Symbol to be used on the expenses section, the Time Format and Day Start Time for the planner, and the country, for which holidays are shown. The options selected in the Settings worksheet will affect the information shown on the Daily Planner. While it is possible to fill these out on the spreadsheet, anything you enter here will not be removed when you change the date on the Date Picker, or by using the settings page, so it is best practice to fill in these sections by hand once the planner has been printed out. The Schedule, To Do Today, People To Contact, Expenses and Notes sections are all left blank. Simply print the page, and repeat the process for every pair of dates you need a planner for.Īny holidays or things to remember will be automatically populated with information you have entered elsewhere on the spreadsheet. In order to select a pair of dates, put an x in the white box beside the dates (making sure you delete the x from any previous selections first). The Date Picker allows you to select pairs of dates to print off day planners for. The mini calendars at the top of the page will highlight both the date of the planner page, and any holidays or events that have been recorded, giving you a handy overview of notable upcoming dates. It shows two days at a time, and is designed to be printed on both sides of a sheet of A4 paper, with a day on each side. This is the worksheet you will use on a day-to-day basis. Creating your Daily Planner Daily Planner
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |