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

Meal planner macros template excel