Free Excel Calendar Template

Powerful Excel Calendar Developed using only formulas

How do you like to have a powerful calendar that could be customised to your needs? A calendar that allows you to

put in your own pictures;
highlight important dates product launches, customers' birthdays, a travel itinerary, duty roster, key dates for board meetings so that you will not missed them out in the midst of your busy schedule;
let anyone with a computer to open and use;
work on dates that goes beyond 2009 with a click of a button;
print on any printer;
use without having to spend a single cent on it.

This Excel calendar is created by John Walkenbach, a Microsoft Excel expert. It is developed using formulas (no macros at all) and works in all versions of MS Excel, including the new Excel version 2007.

With permission from John, I have added functionality to the template to highlight the public holidays in red just by entering the dates into the worksheet, and have demonstrated how this can be done by putting in the public holidays of Singapore. The formula is intelligent enough to mark out Monday as a public holiday if that public holiday happens to fall on a Sunday. Take a look at 9 August 2009, Singapore National Day and you will know what I mean.

If you live in another country, all you have to do is to replace the list of public holidays with yours. I have also put in my excel course schedule in the calendar so that you could see how I use it to highlight our training schedules for next year. Since it is an Excel file, you can create multiple calendars by saving it with another file name. You can create a calendar for office use, another for personal use, etc.

If you like to own a copy of this wonderful Excel calendar, fill up the form given below. It will be delivered to your mailbox almost instantly. If you don't need one now, you can download it first and play around with it later. It's going to show how much more you can do with Excel.

Here's some feedback from users

“The Excel Calendar template is quite useful. With Singapore holidays and relevant details, it's an useful tool in just one page for the entire year. Also, it can be used similar ways for years to come!”
Pradip Muchhala, ST-NXP Wireless

“Thank you for your Template .... very useful for me to plan my holidays ,and important day like birthday .Use for reminder too. Very Well Formated .. user friendly ..”
Goh Siong Ching, Sanyo Electronic Components

“Thanks a lot, Jason! Exactly what I wanted. I only need to tweek the formula a little if I need to add events in the month sheet. Thank you for sharing this tool!”
Felicia Lim

“Thank you for the wonderful excel template. It help me on my project that i am doing. This is a great excel template.”
Syafri

“I found this excellent and really saved me a lot of time trying to develop one. This is exactly what I needed, and also gave me a greater understanding of formulas.”
Sue Caradonna

“Thanks for the excel calendar template. It is very useful and good to track many purpose like Sales Performance, Expenses, Budget, Program or events for the whole of 2009.”
Fiona Soh

“I have been using it to make personalized calendars, since in Portugal, besides the national holidays some towns have their own holidays which are not marked in the standard calendars.

I need that information because of my work since frequently I have to contact people in other towns.

Furthermore, I have to keep track of some colleagues holidays. Having all that information in a single calendar is very useful to me.”
Lensman

“I modified the calendar to display RED/ YELLOW/ GREEN for days of the week where the number of people scheduling vacation could be easily identified by all of the managers and supervisors. Red indicated the number of people scheduled for the day had met or exceeded the daily threshold. Yellow, indicated the number was approaching the threshold. And green indicated there were still positions open for scheduling vacation. This will prove to be quite handy in our workforce analysis.

Thank you for sharing!”
Rich

“It is great ; I am using it to show a full view of my appointments and commitments.”
Christian Labezin

“It's been great. Simple and user-friendly. Its a good find for anyone who needs an excel template like this.”
Dawn Lee

“It is quite useful to plan monthly working as one can plan for monthly work according to the dead lines.”
AS

“The monthly excel calender which was received from your company is very good and useful for our daily ones. this product is good and has a good future in the market.”
J.P.Krishna Prasad

“Although I use Excel every day, I have never used Styles and that is something I intend to start using from now on. I have never had any Excel training and like most people am self taught. But Excel is so full of amazing features that I'm sure that I could save time if I knew of some of the more advanced tools. While programming skills and VBA obviously add much value to Excel, I can see that there are sufficient functions to do many things without that knowledge.

Once again many thanks for the spreadsheet.”
Jonathan Perez

“First of all thank you very much for sending me excel calender template, it is really nice creation, you have done very good job.

I'm using it for my routine time schedule, basically I'm very busy man and most of my time is spending in meetings, so in this regards, I'm getting much more help with this calender.”
ARK

Excel Calendar template

Remember: Your privacy is safe and you may stop further mailings at any time.

PS: We need you to click on the link in our confirmation email to confirm your name and email address so we can verify you are a real person. Please look out for it.