Home > Templates > Templates > Planner Excel Weekly Planner TemplateGet this free Excel weekly planner template. Enter week start date, customize calendar settings, then print the weekly planner sheet, to use all week |
Use this free Excel weekly planner to make notes about your daily plans and activities. See how to use this planner, so you can print a customized calendar every week. There are a few notes on how the weekly planner's formulas work too, if you're interested in that.
This video shows how to adjust the line settings in the Excel Weekly Planner, and how to set up the conditional formatting that controls the lines.
There are 4 sheets in the Weekly Planner Template workbook:
The WeekPlan list is protected, with NO password. The other sheets are not protected.
The first step in using the Excel Weekly Plan template is to go to the Setup sheet, and change the settings there.
Every week, before you print the weekly plan:
A formula in cell D7 shows the weekday name for that date
NOTE: For most weekly calendars, the start date is a Sunday or Monday. However, you can use any weekday as the start date.
In the weekly plan, the weekday names appear at the top. You can show the short name - Sun, or the long name - Sunday.
To change the weekday format:
To change the font formatting, see the Cell Styles section below.
In the weekly plan, there are 3 sections for each day, with a dividing line and heading for each section. You can change any of those section headings, or leave them as they are.
To change a section heading:
If you leave heading 2 or 3 blank, the dividing line for that section will not appear. Here's what the weekly plan sheet looks like, with the new headings, and section 2 heading left blank.
At the left side of the weekly plan, there is a Week To Do List. You can control the line spacing in this section, or remove the lines. In this screen shot, the lines have triple spacing.
To change the To Do line settings:
On the Setup sheet, select from the drop down list in cell C15
At the top left of the weekly plan, there is a space for a weekly note that you want to highlight. For example, you could type:
To change the weekly note:
The message length appears in cell C18. It's just for your information, and not used anywhere.
After you've entered the Start Date, and changed any optional settings, you can print the weekly plan. To print the plan:
NOTE: The Print Area on the WeekPlan sheet only includes the Calendar cells. Even if the formula rows and columns are visible, they won't print.
To make it easy for you to change the Weekly Plan appearance, there are 3 Cell Styles in the workbook:
Cell Style CTX DATE HEADS is used for the date and weekday names, in C4:I5
Cell Style CTX DAY SEC HEAD is used for the Day section headers, in columns C:I
Cell Style CTX QUOTE is used for the weekly note, at the top left, in cell B4
You can modify one or more of the cells styles, to give your weekly plan a different look.
To modify a Cell Style
Here's a quick overview of how the Weekly Planner Template works.
The drop down lists on the Setup up sheet are created with Data Validation. The source data for the drop down lists is stored in named Excel tables, on the Admin sheet.
There are 2 formula cells on the Setup sheet:
There are 3 sets of date formulas on the WeekPlan sheet
There are 3 sets of Day Section formulas on the WeekPlan sheet. The T function is used in these formulas, to return an empty string, instead of a zero, if the linked cell is blank.
There is a simple formula in cell B4, to show the Week Note that you entered on the Setup sheet. The T function is used in this formula, to return an empty string, instead of a zero, if the linked cell is blank.
There is conditional formatting on the WeekPlan sheet, to
NOTE: You can see ths setup steps for the condtional formatting in the video, at the top of this page.
The heading cells for Day Sections 2 and 3, (C16:I16, C28:I28), have this conditional formatting rule, to check if the cell contains an empty string:
If that is true, the cell is formatted with no top border
There are 4 different options for the Week To Do List lines -- None, Single Spaced, Double Spaced and Triple Spaced. Instead of setting up 4 different Conditional Formatting rules, a worksheet formula checks which rows should have lines.
Here's how the worksheet formulas are set up.
On the Admin sheet, cell C3 is named ToDoLinesID, and it has an INDEX/MATCH formula to find the ID number for the option that you selected.
That ID number is used in formulas on the WeekPlan sheet, in hidden columns K:L
The MOD function returns the remainder, after the number in L12 is divided by the ID number selected.
In the Week To Do List cells, this conditional formatting rule is used:
If that is true, the cell is formatted with a bottom border
And here is the Week To Do list, with lines set to Triple Spacing. Every 3rd row is TRUE, and shows a line.
Get a copy of the free Excel Weekly Planner Template workbook. The zipped file is in xlsx format, and does NOT contain any macros.
Last updated: March 28, 2023 7:43 PM