Monthly Event Calendar
- 9'139 Downloads
- 149 KB File Size
- January 3, 2022 Updated
- 15 Number of comments
Following the soccer fixtures and excel calendar I made, I got another idea about putting my favourite teams fixtures in calendar, and try to make it automatic, so I can changed the date, the team or add the new date or team easily or even combine the soccer league fixtures, the champions league fixtures and Formula 1 schedules. That is the first idea, because there are still many ideas that can be implemented in this event calendar.
I have divided this excel spreadsheet into three different layouts. And the first one is one monthly layout. I add the capability to change not just the month but also the year, so you can use this every year.
The guidance for using this spreadsheet are as follows :
- This is the one month event calendar where you can only see the event only for the month and the year that you fill on the corresponding cells.
- Enter the date and the corresponding event in the blue cells at the left side. You can fill one by one or just copy the date and event from other sources. You don’t have to fill it in order, as you see in the sample data in the spreadsheets, I put the fixtures of AC Milan from Italian Serie A fixtures and followed by the fixtures from Barcelona. You can put the champions league event or Formula 1 or MotoGP or your lover birthday after that. The formula inside the calendar cell will find the corresponding event automatically.
- I limit that only 3 (three) events can be shown in the corresponding date, so if there is more than 3 events at the same date, only the top three events in the event columns will be shown.
- You can change the lay out, the colour or change the cell format, but please be careful with the formula, especially the formula that return error result, since I have to cover it using white colour. I protect this sheet without password, so you can just unprotect this sheet from the excel menu.
- Finally, if you make some changes in this excel spreadsheet or rename to other name, I would be pleased if you keep my link available in the spreadsheet.
Openoffice version is included for this template.
Three Months Layout
Three-Monthly Event Calendar: I am including a three-monthly version where you can see your events marked in three-month calendar layout in one worksheet.
Six Months Layout
Six-Monthly Event Calendar: This one has 6 months in each worksheet.
Mini Month Table Layout
This is another calendar I made, based on my perpetual monthly event calendar, where I put additional two mini layout month next to the main month. I put also a condition where the cell format of corresponding dates in those 2 months will be changed based on related events. I don’t know whether this will be more useful or not. But, I thought this is good as an accessories.
OpenOffice version is included for this one.
Six Event Rows Layout
This calendar can accommodate until 6 to-do list or events at the same dates. And you still can put additional one holiday or one important event on top of the row. And there are additional columns where you can put your time consideration of those events or you can leave it blanks.
There are two worksheets that are shown in this spreadsheet, the first one is “todo-holiday-event” worksheet. And you can start to use it as your 2010 monthly calendar by setting the month and the year in the first rows of this worksheet to January 2010. You change it according to your preference. After that, you can put your to-do list in to-do list column. You can use this list as your reminder list also. For example, you can put your favorite movies schedule, your concert show, your favorite sport teams schedule etc. And you don’t have to type it in sequence, because the excel formula will display and order it automatically in the calendar. So, you can add it anytime without thinking of ordering the dates.
The second column is a holiday column. There are US holidays time that I put as a default. You can change it based on your country national holiday, or your own private holiday. The description of the holiday will be displayed next to the date of the calendar and the row of that date will turn into red.
The third column is an important event column. In case you want to separate your important event with your to-do list, like your birthday or your beloved one birthday, you can put it in here where the event will be displayed differently in the calendar. It will be displayed next to the date of the calendar with blue color. It will share the place with the holiday information. So, if the important event and holiday are happened at the same date, the important event will become priority to be displayed.
The second worksheet is a calendar worksheet where you can see your customize calendar before you print it. There is a slider tool on top of the calendar that you can use to slide between months. You can slide it right to go to the next month and slide it left to go back.
We are sorry 🙁
Help us improve!
How we can improve this template?
Ange ( )
Hi, this is a great planner that I want to use for my work but I am having trouble when I unprotect the sheet and add in my data it doensn’t keep the formula year by year or month by month, instead it all is the same data – please help! Thank you =]
Dale Hallam ( )
I really like this event calendar and it could help me greatly but I am unable to change the year or month without errors. Could I know if there are any fixes for this.
Thank You in advance.
RoxAnn ( )
do you have this updated for 2012? it won’t let me change 2009. thx
Brigitte ( )
hello I am using the Event Planner calendar – we love it but we need more than three line items in the calendar section per date. We would like to have 6 lines of availability for each date within the calendar – how do we do that? Thanks so much these are really great resources.
Fez ( )
First of all i would like to let you know that your work is Phenomenal and I admire it. gr8 work. I have donwloaded your Monthly Event Excel Calendar and it works perfect. Just would like to ask you is there a way to make 3 events per day to 5 events per day? Can you help me to add 2 more event per day? I would appreciate you help.
Diana ( )
I am impressed of the templates I found here. Excellent work! Congratulations and thank you for sharing!
I try to create an annual holiday planner for a large number of staff. Any suggestions?
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 Calendar. Thanks 🙂
William Greenberg ( )
I noticed that a couple of people had asked about adding rows to each date, but I did not see a response. I just thought I would ask again. Could you help me figure out how to do this?
George A ( )
Great calendar tool. Any chance you have a version that allows for and shows events that span multiple dates?
Thanks again for your great effort!
Terri H ( )
Wow, what a great tool you have offered, and obviously spent some time developing! I saw this and immediately thought about using it for a bill-due-dt calendar.
Unfortunately, we have a LOT of bills and in some cases, I need more than the 3 lines available. I tried to add the additional rows, but can’t seem to get the formula right, and while I understand basic, simple formulas, this one has gone past my limited ability.
Could you give me any advice on how to go about this? Just thought I’d ask for a little guidance, however, I DO understand if you don’t have the time nor inclination, since you ARE offering this for free, of course.
Thanks again for your hard work & effort.
R. Musadya ( )
You should activate the “Analysis ToolPack” Add-ins in your excel. By, default excel doesn’t activate this add-ins. Go to menu Tools > Add-Ins and you tick Analysis ToolPak and your problem will be solved.
Noel Colon ( )
I just download you 3 & 6 month calenders but the all have in error after the 24th of every month can you fix that?
Thanks in Advance
Gagan ( )
Great template but i having hard time to find the download link. How do i download the template?
John Spruill ( )
Looking for your 2020 Monthly calendar events like 2019 version was 2019_Calendar_Model 13
José Flores ( )
Great template! I would like to have 6 lines of availability for each date within the calendar – how do I do that?