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

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


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.

 


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.


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

Advent

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.

Advent


This website offers some free multiyear calendar templates since mid-2012. The templates are quite popular and have been actually downloaded more than 100,000 times.

Recently, Damian Strojec provided a Polish translation of the multiyear calendar template, which also contains the most popular Polish holidays. Thank you very much, Damian!

Excel Calendar Polish

I added the Polish version to the table on the corresponding section for the multiyear calendar templates of the download page.


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.