(C) 2009 - 2018 by Mourad Louha · All rights reserved

All posts tagged Calendar

Excel Advent Calendar

Categories: Calendar Templates
Comments: No

Petros Chatzipantazis asked me some days ago, if I was interested to translate his advent calendar to german and to publish it on my blog. I thought the idea for the advent calendar was great, so it took very short time to accept his suggestion. The advent calendar includes quizes from Petros, Chris Macro and me. Each day, you can answer to a question about Excel – some of these questions are relatively easy and others are more difficult. Each author provided some questions. I provided the questions in German. Petros and Chris provided questions in English. Petros also published a post Anticipate Christmas by counting down the days using Excel on his blog. The following screenshot shows the german version for the advent calendar


The advent calendar is available in two versions. The first version does not need anything else than the activation of macros. You can answer the questions by clicking on the buttons next to the questions, which appear in the ribbon tab “Advent calendar”. And you can select a question by clicking on the day numbers or by using the buttons “Next question” and “Previous question”. However, some of the buttons just only show a message box; for example is you try to choose an author. This is due to the fact, that’s not possible to change the ribbon tab at run time via VBA.

The second version of the advent calendar uses the Ribbon Commander Framework. This framework allows dynamic Ribbon UI development from VBA & .NET and therefore the second version of the advent calendar offers more possibilities. After downloading the framework (which can be freely tested for 30 days), you can download the advent calender from its integrated Add-In-Manager. The framework can be directly downloaded from the source site or you can use the web laucher, which is an Excel-Add-In and does all work for you via Excel.


We have released the French version of our multiple year calendar template for Excel 2007 and Excel 2010. The calendar includes the official holidays for France. However, due to some regional differences for the holidays, you may activate or deactivate some entries.

The calendar can be downloaded from the follwing page, providing an overview of all current releases and translations of the calendar: “Overview of the Excel 2007 and Excel 2010 Calendar Templates for 2011

We will publish are more detailled manual in french (as included in the calendar templat) as soon as possible. The manual will the be downloadable as a PDF file.

Each calendar template contains a language and country code representing the language used by the template and the targeted country. For example, the code “DE-DE” is used for German and Germany and “EN-US” is used for English and the United States. The download files and the calendar files themselves also include this code in their names. And we have already entered the most important official holidays for each targeted country in the respective calendar templates.

Manuals for the calendar templates

I have published an online version of the manuals for the calendar templates in English and in German to this and the German sister blog. The manuals are describing the features and functions of the calendars. A shortened version of the manuals is also included in the calendars.

Language Manual Download
English Link to the blog post NA
French NA NA
German Link to the blog post NA

Download of the calendar templates

The following versions are currently available for download. Please note, that we are using a script which checks the referrer sent by the browser for ensuring that the download link is called from our site. Normally, the common browsers are sending the referrer from the last visited site by default. However, if you or someone else has disabled this function, the script redirects you back to the homepage when clicking on the download link. In case you cannot enable the referrer in your browser, please send me an e-mail to vba(at)maninweb(dot)de. I will then send you the calendar template either via e-mail or create a special download link for you.

Language Country Code Download
Englisch USA EN-US Version 1.10 – Build 200111
French Belgium FR-BR Version 1.10 – Build 200111
  France FR-FR Version 1.10 – Build 200111
German Austria DE-AT Version 1.10 – Build 200111
  Germany DE-DE Version 1.10 – Build 200111
  Liechtenstein DE-LI Version 1.10 – Build 200111

If you would like to inform us about an error in the calendar template or send us suggestions and wishes for the next versions of the calendar template, please use the comment function in this post. Finally, we would like to thank all users who had downloaded and are using our template.


We have modified and improved the calendar by adding a new option for selecting the date format from a list. Common German, English and French date formats are include in the calendar. You can also add up to two user specific date formats to the resource sheet.

The setting concering the date format is only from interest, if you are using an operating system which does not cover the fate formats included in the calendar. For example, if you are using an Italian version fo Windows, the English date format “MM/DD/YYYY” may not work. So, you may then enter your date format to the resource sheet. You can reach this sheet by clicking on the “Next” icon from the settings sheet.

We have also updated the detailled documentation for the calendar in the article „Excel 2007 and 2010 Calendar for 2011 (EN-US)“. The download link remains unchanged and you can download the file from the previously mentionned article.


Please note that I have modified the content of this article by adding the detailed description for the calendar and that I have shortened the article “Our contribution to the Microsoft 2011 Calendar Contest – US-Version” which previously included the description. The reason for this is that I would like to avoid confusions between the versions of the country specific calendars and want to keep in sync with the German and English articles.

On the occasion, when developing the German version of the calendar, I have added some new features to the calendar and updated the US-Version. And I have also fixed some minor bugs and extended the holiday calculation algorithms. These algorithms automatically calculate the dates of the holidays for the selected year, both fixed to a date and relative to each other. So, in general, there is no need to reenter the holidays each year.

Update on 01/05/2012: Please note, that the calendar can also be used for 2012. Just modify the year on the settings sheet.

At this point I would firstly like to thank Andreas for also testing the new version. And also thank Claudia for her support to the design. Of course, the current version for the calendar can be downloaded at the end of this article.

The calendar, originally developed for the Microsoft Office Calendar 2011 Contest, was made in Excel 2010 and has a similar layout to the Excel Soccer World Cup 2010 Planner, which has been downloaded over 375,000 times from its website. A navigation bar on the top of each sheet in the calendar allows you to easily navigate through the calendar.

Excel Calendar 2011

Read more

Update on 11/04/2010

I have shortened this article by moving and updating the description of the calendar to the article “Excel 2007 and 2010 Calendar for 2011 (EN-US)”. You can also download the latest version of the calendar from there.

The reason for this is, that I would like to avoid confusions between the versions of the country specific calendars and want to keep in sync with the German and English articles. Please also note, that the calendar can still be downloaded on the Office Templates Website. However, it is possible that the file on the Office Templates Website has a lower version as the version on this site and therefore does not include all current features.

Previous content without moved parts

Microsoft is currently organizing a 2011 Calendar Template Contest on their Office Website. Entries have been (are) accepted there through September 30th and the winners will be announced October 6th to 13th on the templates home page.

We are pleased to inform you, that we are participating to the contest by providing this multiple year Excel 2010 calendar. As the contest is primarily focused on the US market, we only included the official holidays for the United States in our template at this time. But we are planning to release localized versions for some European countries as soon as possible.