I have published a couple of calendar templates earlier. The Custom Calendar (U.S.) works for any year and automatically calculates the U.S. Holidays. The Custom Calendar – 2013 (Tamil) displays the Tamil Nadu Government holidays for 2013. Both templates allowed a lot of flexibility such as starting your week with any day and entering up to 100 of your personal events.
I am now publishing a calendar template which I am calling All-Purpose Calendar Maker. It can be used in any scenario (schools, companies, libraries, etc.) and any country (as it does not have any feature that is country specific). It has more flexibility: you can choose the weekend(s) as any day(s) of the week and you get to choose up to 5 different types of events (100 events – grouped in up to 5 types) you want to have displayed.
12 Month Calendar in Excel – Calendar Excel Template
Handles 12 types of recurring events (Daily, Weekly, Monthly, Nth Wkday of Mth, Last Wkday of Mth, Last Day of Mth, Nth Busn Day of Mth, etc.)
HOW TO USE THE TEMPLATE
Step 1: Enter basic information
Calendar Excel Template – Step 1
Start Date
Choose any date and your calendar will have 12 months beginning with the month of this Start Date
Starting Day of Week
This allows you to start your week on any of the 7 days
Name
This will be displayed on the calendar. For example, you can enter your organization name.
Step 2: Set your Weekends
This option allows you to customize the weekends according to your needs. Choose ‘Yes’ if you would like a specific Nth weekday of a month to be considered as weekend day.
Calendar Excel Template – Enter Weekends
For example, in the image above, all Sundays and all second Saturdays are considered as weekends.
Step 3: Set up to 5 types of events
You can enter your own (up to 100) events that will be displayed on the calendar. You also can group those under 5 buckets (types). First, you will enter the names for the Event types. There are 5 pre-chosen colours and the colour next to the Event type will be used to highlight the corresponding dates on the calendar. The order of these events will be used to prioritize when multiple events happen on the same day. This has been explained more later in this post.
Calendar Excel Template – Enter Event Types
In the image above, for a school scenario, I have chosen 5 event types: Holidays, Test Days, Birthdays, School Events and Homework Due.
Step 4: Enter up to 100 events
You can enter up to 100 events and these events will be highlighted on the calendar. You enter the name of the event, event date and event type. By choosing the event type, the dates will be colour-coded on the calendar according to what you chose in Step 3
Calendar Excel Template – Enter Events
Step 5: Choose a design
You can choose 1 page – 12 Month Calendar or 12 Pages – Monthly Calendar to view and print your calendar. The calendars are fully automated and do not require any further inputs. You can also export the calendars as PDFs and share.
SCREENSHOT (1 PAGE – 12 MONTH CALENDAR)
Calendar Excel Template – 12 Month Calendar
If there are multiple events on a day, all of them will be displayed on the event list. On the calendar itself, the higher priority colour-code will be applied. For example, in the screen shot, you can see that there are two events I Mid Term Test Ends (Test days) and Student 3 Birthday (Birthdays) on 17th November. The colour for Test days is used on the calendar since it’s higher than Birthdays on the list of event types.
SCREENSHOT (12 PAGES – MONTHLY CALENDAR)
Calendar Excel Template – Monthly Calendar
On the 12 pages (1 page for each month)Monthly calendar, up to five events will be displayed for a specific day on the calendar. The colour-coding of dates work the same way as in the 1 Page – 12 Month Calendar.
If you like the Calendar Excel Template, share it with others. If you would like to see any changes to the template, provide your feedback in the comments below.
64 Comments
I THINK ONLY CALENDER WITHOUT EVENTS OPTION IS NOT AVAILABLE IN UR FARMAT
Currently, our template is designed to work on Excel and we have not tested on other worksheet applications. We used simple Excel formulas, hence you can download and test the same and please do let us know if it works.
You can login to your account at the below link to download the latest version of the purchased template: https://indzara.com/my-dashboard/
You do not have to purchase the template twice to get the latest version of the template. Please let us know the template that you purchased again for new version and we will initiate the full refund for the same.
Currently, this template is limited with 5 event types. For more event types, requesting to check our Event calendar maker premium template at the below link: https://indzara.com/product/event-calendar-maker/
Thanks a lot for providing this template which helps me a lot to create a release calendar.
Wondering about the ‘Notes’ section which I cannot edit due to password restrictions.
64 Comments
I THINK ONLY CALENDER WITHOUT EVENTS OPTION IS NOT AVAILABLE IN UR FARMAT
un protected it by indzara password, issue resolved, Thanks for ur free templaes
Will this work with LibreOffice?
Thank you for showing interest in our template.
Currently, our template is designed to work on Excel and we have not tested on other worksheet applications. We used simple Excel formulas, hence you can download and test the same and please do let us know if it works.
Best wishes.
HOW DO I UPDATE MY 15 SPREADSHEET THAT I HAVE ALREADY BOUGHT. THE ONE I HAVE ACTULLY BOUGHT A SECOND TIME.
You can login to your account at the below link to download the latest version of the purchased template:
https://indzara.com/my-dashboard/
You do not have to purchase the template twice to get the latest version of the template. Please let us know the template that you purchased again for new version and we will initiate the full refund for the same.
Best wishes.
Hello,
Very Useful Template that comes Free.
Can I add more than 5 types of event ? example 6 or 7 ?
Thank you for sharing your valuable feedback.
Currently, this template is limited with 5 event types. For more event types, requesting to check our Event calendar maker premium template at the below link:
https://indzara.com/product/event-calendar-maker/
Best wishes.
I would like to add more than 100 events. Is that possible?
Thanks for using our template.
As of now the number of events is limited to 100.
Please see Event Calendar Maker template for up to 300 events. https://indzara.com/product/event-calendar-maker/
Best wishes
Hi Ind Zara,
Thanks a lot for providing this template which helps me a lot to create a release calendar.
Wondering about the ‘Notes’ section which I cannot edit due to password restrictions.
Any help or advise is more than appreciated!
Have a nice day 🙂
Thanks for using our template.
Please use “indzara” as a password.
Best wishes