- 4'484 Downloads
- 154 KB File Size
- January 4, 2022 Updated
- 15 Number of comments
This monthly planner is created with different approach compare to weekly planner and daily planner template I have posted earlier. It is created based on the monthly event calendar with additional column for time so it can be used as a planner instead of just calendar.
You can make this planner as a printable blank planner or you can add to-do list in this planner for one month period. There are maximum 3 to-do list that can be inserted in the planner due to layout consideration. I will make the planner with more than 3 to-do list later, because I don't want to change the original monthly calendar that I used as its basic template too much, because to accommodate more than 3 to-do list I have to change the structure of the column and formula. You can put also hour information in the to-do list column as seen in picture.
And there is a holiday and an event column that will shown up in the planner. Since I only spare one cell to be filled next to the date inside the planner, there is only one event or one holiday can be shown up. If both event and holiday share the same date, the cell will show the event information because I put priority of event is higher than holiday.
And below the main dates, there is a note and a supporting calendar as a reference to see the dates one month before and after. And to ease you to see the plan one month ahead, I set a slider bar on the left corner of the planner. You can slide it right or left to see your plan in your targeted month. And you can set the starting month and year in the Todo-holiday-event worksheet together with to-do list, holiday and event information I explain to you in the beginning.
There is a supporting calendar worksheet where you don't have to do anything, except if you want to learn formulas or do some modification. I used this worksheet as a reference to display supporting calendar in the planner.
That's all guys. You can download the file here.
We are sorry 🙁
Help us improve!
How we can improve this template?
ALEX ( )
Thanks so much!!! I had created one in Excel that matches my at a glance 2013-14 planner but yours is much easier. PS Is there a way I can take of the Saturday as I only need Monday-Friday and make the colums a bit wider and taller? Beautiful job, I wish I new how to do interactive work in excel.
Lisa ( )
I agree with Kurt. How can I add a date range so it will populate each day in the range with the “TO DO” item? Please help. Thanks.
Chee ( )
How can I add more rows to the holiday table in the todo-holiday-event worksheet?
mohamed ( )
How can I add rows to the todo of each day?
TJ ( )
Having the same issue as Amanda but i cant even get the text to show up ?
How can i solve this ?
Amanda ( )
I have added many holidays and events, once I get past a certain point (about Row 34 in the Todo tab), the colour does not fill in for the Holiday or Event anymore. I have managed to get the text to show up, but am stumped on how to get the colour to show!
Can someone help?
Anand ( )
I am trying to fix the “#Name” problem in the last few weeks. The fix suggested; by cilcking Add-ins and then Analysis toolpak does not seem to change anything.
Is it because I have Excel 2003?
Kurt ( )
Is there a way to link several dates together such as; “Vacation 1-14 through 1-25-2010? having this time period linked or illustrated as one event occurring over several days? I am using Monthly Planner. Thanks 🙂
svrobin ( )
This is just what I have been looking for, although I need to tweak it a bit. I would like to learn more about how it works but can’t find the code for it. Is there anyway I can get a hold of the code for this?
Leena ( )
Can I set the work schedule to do list every Monday or Every date of each month without filling in every month manually?
Peter ( )
nice spreadsheets :-
Month and years shown in ‘Monthly Planner v.1.2 cant be referred to the cells (that it should being). The outgoing data is from ‘Supporting Calendar’, in the A-column but no data shows up.
Just wonder where they are…
R. Musadya ( )
@ mel: all the pages are linked, just fill the todo-holiday-event worksheet and all filled information will be displayed in the calendar based on its date
@Candice: you should activate the analysis toolpak addins to make the excel function work properly. Go to your excel menu > Tools > Add-Ins and tick Analysis ToolPak.
Candice ( )
These are awesome …. can you correct November dates – Nov should start on Sunday not Thursday.
mel ( )
Are the pages linked or do you enter the information on which ever you choose to?
marlina ( )
LOVED YOUR CALENDAR!!! I have been looking for something like this for a very long time. How can I add more rows to each date? How can I add more color coded events?