Monthly Planner

Posted on July 17, 2009
Filed Under Calendar | 18 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.

You can read and download my other templates below :

Tags: free monthly planner, free printable monthly planner, monthly planner template, monthly planners, printable monthly planner, printable monthly planner sheet

Comments

18 Responses to “Monthly Planner”

Henry Barahona on July 28th, 2009 5:46 pm

quisiera me envien este planificador para poder usarlo en mis cosas. Gracias
marlina on July 28th, 2009 5:48 pm

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?
mel on August 5th, 2009 3:31 am

Are the pages linked or do you enter the information on which ever you choose to?
Candice on August 7th, 2009 9:54 pm

These are awesome …. can you correct November dates – Nov should start on Sunday not Thursday.
admin on August 8th, 2009 1:38 pm

@ 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.

Regards
Peter on October 11th, 2009 8:51 am

shoot…
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…
Leena on December 2nd, 2009 4:31 am

Great!

Can I set the work schedule to do list every Monday or Every date of each month without filling in every month manually?
svrobin on January 8th, 2010 2:40 pm

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?
Kurt on January 19th, 2010 8:04 pm

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
Anand on January 26th, 2010 6:46 pm

Hi

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?
Amanda on March 22nd, 2010 5:11 pm

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?
A on August 30th, 2010 4:26 am

aasaS
TJ on December 2nd, 2010 12:01 am

Having the same issue as Amanda but i cant even get the text to show up ?
How can i solve this ?

TJ
Alyas Sardar on March 6th, 2011 2:36 am

Nice work. God bless you.
Ilio on September 6th, 2011 9:55 am

sono interessato alle vostre applicazioni
mohamed on October 31st, 2011 2:41 pm

How can I add rows to the todo of each day?
RoxAnn on January 10th, 2012 4:42 pm

2012? thx
Chee on January 14th, 2012 7:38 pm

Great template!

How can I add more rows to the holiday table in the todo-holiday-event worksheet?

Please assist.