How to add national holidays in Outlook 2010
September 3, 2010 24 Comments
You can easily add national holidays to your calendar in Outlook to make sure that you don’t forget those extra days when you don’t need to go to work.
Before you do though, it is worth noting that Microsoft have published a whole bunch of wrong holiday dates in Outlook 2010 for at least 23 countries, including many future UK Bank Holidays. You should probably read my other post about the errors and download one or more of the files with corrections for them before you go ahead and add anything.
This article is intended to help you add national holidays, remove holidays with an incorrect date, and use Outlook categories to make these stand out on your calendar. Although I wrote this to accompany my post about incorrect dates in 2010 to show you how to actually add or remove these from your calendar, what follows applies pretty much the same to Outlook 2007 and older as well, although to be fair I have not attempted to test this in any step-by-step fashion for Outlook 2003, 2000, 97 or older as I no longer have these antiquated, steam-driven versions installed for me to access.
Adding Holidays to your Outlook 2010 Calendar
The normal way to add these holidays from the outlook.txt or outlook.hol file already installed on your machine is through Outlook’s own options as follows:
In Outlook 2010 go to File > Options then click the Calendar tab on the left, then click then “Add Holidays” button and carry on as described below.
If you are still using an older version, then for Outlook versions up to 2007, go to Tools > Options, then on the Preferences tab click on the “Calendar Options” button, then click on the “Add Holidays” button in the middle of the dialogue box which appears.
Now in either case you will see a list of countries you can add. Tick the boxes for the ones you want, and click OK. If you have previously added any of the countries you chose this time you may see a warning message that this may create duplicate entries. If you previously added the incorrect entries for a country, it is usually better to delete them all first (see below) and then add a correct set instead. If your administrator has provided any specialised versions of the file, you may see unusual “countries” listed, which you can also add in just the same way.
If you try to add the holidays for the same country more than once, you will get a prompt like the one below to check if you really want to do this. If you know you only have a special subset list to add, or you have deleted the ones you already installed, you can safely say yes to this, otherwise say no to avoid any duplication.
What do the holidays look like?
All the holidays you import for the countries you chose will be added with the following characteristics:
- They will be an All-Day Event for the date in question
- The time will be marked as Free (always the default for an All-Day Event)
- They will be in a Category called “Holiday” (see note below)
- The Location will be the name of the country where the holiday applies (we will make use of this later if you need to remove any)
- There is no reminder set for these entries (regardless of your default reminders setting)
What does the “Holiday” category do?
Out of the box, nothing. Outlook has had a feature for many versions which enables you to categorise items according to categories you define and show them in colours you associate with those categories. In Outlook 2010 you can pretty much define as many categories as you want (to the point where they become unmanageable), although in the drop-down list under the “Categorize” button you will only see the fifteen most recently used for that type of information (ie. 15 recently used in your Calendar, Tasks, Mail, Contacts are remembered as separate lists).
Categories are especially useful for Calendar entries as they show up in colour in your Calendar and the To-Do bar. If you add a flag to an email to follow it up, you can easily also add a category to it so the associated colour shows up in the To-Do bar as a visual clue which might remind you why you decided to follow up that item in the first place.
In your Mail or Contacts view the “Categorize” button is on the Home ribbon; in your Calendar you need to select an entry and it will be shown on the additional ribbon which appears (for a meeting or appointment as appropriate). The drop-down menu (shown below in a cut-down form) includes an option for “All Categories”.
When you choose this you can add new categories, rename existing ones and choose different colours to associate with them. So if you simply select an existing one or add one, and name it “Holiday”, Outlook will start showing items already saved using this category in the colour you choose.
As an aside, the same applies if you create a meeting request, categorise it and then send out invitations to your colleagues. The meeting will remember the category you assigned, but this will not change how it shows up in the other person’s calendar. If they do have a category of the same name, or later add one, it will show up in the colour they choose to use for this.
Note: All Day Events and Time Zones
Aside: All-Day Events are intended to take place on a specific date and are NOT “time-zone aware”. For example New Year’s Day is 1st January, it does not start half way through the day even if people around the world start celebrating at different times according to when midnight comes around in their time zone. Normal timed appointments and meetings are shown to a user as taking place at the specified time adjusted for their time zone. This is great for international corporations when sharing and viewing other people’s calendars in order to fix up a time for a remote meeting, telephone call or video conference, as you don’t have to think too hard.
Adding holidays directly from a new Outlook.hol file
The alternative way to add holidays is to start Outlook, then simply find any correctly formatted .hol file (such as the ones linked from my article about the incorrect holiday dates in Outlook 2010) and double click it.
Outlook will then prompt for you to choose a country in the normal way, and you may get a warning about duplicate entries, but if you know the file only contains some specific subset of dates (such as only the lieu dates for Christmas and New Year) then you can go ahead quite safely.
Removing Holidays from your Outlook Calendar
You might need to remove holidays from your Outlook Calendar for various reasons:
- If you still have holidays going way back from previous versions of Outlook you have used
- You have holidays showing for a country you no longer need to see (maybe for a supplier or customer you no longer deal with)
- You added holidays before you realised some of them might have been incorrect
- After adding holidays for multiple countries you have lots of duplicates for dates which are celebrated in many countries (eg. New Year, Christmas, Easter, various Islamic festivals and so on)
- Some of the holidays you added do not apply to you (eg. in the mainland UK you may not be interested in the holidays which only apply in Northern Ireland such as the Battle of the Boyne and St. Patrick’s day)
I have seen various articles in the past which discuss using the categories to search on and identify these, but I find this is not ideal if you have added multiple countries, or when you have also added your own holidays for time off work and used the same category for these dates as well. I would suggest instead using the “location” which you might normally use to show where an appointment or meeting is to take place, such as in a booked room or more generally a particular site, office or even town.
Change your view and sort your calendar entries
So, to start off, in Outlook 2010 open your Calendar and on the View ribbon at the left hand end click on Change View > Events. This will change to a list view with information in columns (rather like a view of email messages), but filtered to show only All Day events, such as holidays. (You could equally choose the more general “List” view and achieve the same goal of seeing things in columns but there will be more entries to go through).
In Outlook 2007 and earlier, you can get to a very similar column format from the View menu > Current view > Appointments.
Once you have your column layout, the first thing to do is sort on “Location” by clicking on that column heading. I would then usually also sort by Subject and by date (this might be labelled “Recurrence Range Start” if you are using the same view I suggested above). To sort on these additional fields, hold down the Shift key while you click on those headings, so you now have everything sorted by Location (eg. all “United Kingdom” together, then by subject (“Christmas Day” all together) then by date, which in most cases will be the year for these annually occurring holidays.
Selecting multiple entries to delete
You should now be able to easily scroll down to find and identify any entries you don’t need, such as duplicates. If you have imported the same holidays twice then you may need to select every second line. To do this use the usual method of holding Ctrl while clicking to select many individual lines before pressing delete to get rid of them. To select a whole block and get rid of them click on the first item then hold Shift and click on the last and you will get a continuous set from one to the other. I would suggest you do this to remove all the holidays for the United Kingdom because you know they include wrong data and you will want to start from scratch before importing a new set of corrected date.
If you import the same holidays twice (despite Outlook warning if you try to do this), it is usually quicker to select all of them (both copies) and delete, then re-import once, rather than selecting alternate (duplicate) rows in the list.
I often import holidays for other countries where I have business relationships so I can easily see that other people are not working, but I don’t need to see things like Christmas and Easter multiple times, so I tend to go and delete all the entries for these which are the same as in the UK. Similarly I tend to delete the Battle of the Boyne and St. Patrick’s day entries which are included for Northern Ireland, but since I am not there I don’t get to take a day off then so I get rid of them. (You can’t miss St. Patrick’s round here anyway for the number of fake Oirish pubs that are bedecked and festooned in green shamrock bunting for two weeks prior to the big day and even bigger night). You might not want to remove holidays for other countries if it is important for you to know if they actually do observe it as a holiday of course.
Don’t forget to switch back to a normal Calendar view when you are done, so in Outlook 2010 go to the View ribbon > Change view > Calendar (in older versions use View > Current view > Day / Week / Month).
In some countries it can be easier to simply ignore many of the dates provided in the Outlook.hol file and just create your own recurring events. For example in the UK there are Bank Holidays traditionally on the first and last Mondays in May, and the last Monday in August. (except in Scotland, who do it on the first Monday in August instead). This may not be 100% accurate when special cases arise (eg. Spring Bank holiday in 2012 has been moved form May to June – see my post about incorrect entries for more information).
It is also no use for things such as Christmas Day – the date of the Christian festival may be fixed, but the Bank Holiday may be observed on a different date if Christmas itself falls on a weekend. In the UK the rule is always to observe the day on the following Monday (and / or Tuesday if Boxing day also falls on the weekend), and likewise for New Year’s day. However, in other countries they take the Friday in place of a Saturday, and the Monday in place of a Sunday (ie. the nearest day) – I’m fairly sure this is the case in the US for example.
Do you have any special ways you use the features of Outlook for managing holidays? Any workarounds for strange recurrence patterns? Have you had problems in the past or simply never used the feature at all? All comments welcome!