Last reviewed on February 16, 2015   —  33 Comments

Adding Outlook's predefined Holidays to the calendar is a very simple process:

Add Holidays to Outlook's Calendar from the Calendar options dialogIn Outlook 2010 and Outlook 2013, go to File > Options > Calendar and then click the Add Holidays button. Select the desired Holidays and click OK.

In Outlook 2007 and older, go to Tools > Options > Preference tab > Calendar Options and click the Add Holidays button. Select the desired Holidays and click OK.

It can take a few minutes to add all the holidays, depending on how many countries you are adding.

While major religious holidays are listed with the holidays for some countries, there are separate listings for Christan, Islamic, and Jewish religious holidays.

You will you receive the following message if you previously added the holidays for a specific country. However, if you are upgrading Outlook or using an updated HOL file, it may be detecting older holidays. If you choose Yes and discover your holidays are duplicated, you can delete them.

Holidays for [location] are already installed. Do you want to install them again?

See How to Remove Duplicate Holidays From the Calendar for complete instructions.

To use a script or PowerShell to automate the holidays installation for users, see Outlook Code: Importing bank holidays from an Outlook.hol based CSV file.

Move Events Manually | Create a Custom Holiday File | Custom HOL sample | More Information

When the Holiday file is wrong

The question a lot of people ask:

Why does Outlook put some Holidays on the wrong date?

I don't recall any version of Outlook shipping with a perfect Holiday file.

The problem is in the Outlook.HOL file used to import holidays - the author (or authors) get some dates wrong. While we expect perfection from them, to be fair, with hundreds of locations and thousands of dates in the HOL file, its easy to make mistakes. (There are more than 21,000 holidays in Outlook 2010's HOL file.)  However, it shouldn't be that hard to get common holidays, like the Monday after Easter right (that is one of the big mistakes in Outlook 2010's HOL file.)

You can either move the events to the correct date, edit this file yourself, or download an updated version. You can even create your own HOL file.

A link to an updated Holiday file containing dates through 2028 is available at Missing Holidays. For Outlook 2002 and up. Note, this is the same file that is included with Outlook 2010 but contains the correct dates for Easter Monday.

Move Events Manually

To fix a holiday that's already in your Calendar folder on the wrong date, just drag the item to the correct date.

Fix a Holiday File

Outlook stores a read-only text file called Outlook.HOL in the installation directory for your version and language of Office (ie, C:\Program Files\Microsoft Office\Office14\1033), which it uses for the Options > Calendar Options > Add Holidays feature.

You can open the HOL file in notepad and edit it.

  1. Start Windows Explorer, locate the Outlook.HOL file. (You may want to make a backup copy.)
  2. Right-click on Outlook.HOL and choose Open with then select Notepad from the list.
  3. To edit a specific country's dates, use Find to locate the Country by name and edit the dates.
  4. To add a new location, press CTRL+END to position the insertion point at the end of the file.
  5. Type a new country header and custom holidays using the format described below.
  6. Save and close Outlook.HOL. Note: Due to security features in newer versions of Windows, you will need to give your Windows account permissions to write to the Office\xxxx folder.

Create a Custom Holiday File

Because of tighter security in current versions of Windows, it's generally easier to create a new HOL file. This has one advantage: you only need to double click on the file to open the Add Holidays dialog. You do not have to go to Options > Calendar > Add Holidays to add the holidays to your calendar.

The Outlook.HOL file lists holidays in the following format, one date per line:
[location] ###
Holiday description, yyyy/mm/dd
Holiday description, yyyy/mm/dd

The ### is the total number of holidays listed for the location (or country). Note that there is a space between the bracket and the number. On each holiday line, there is a comma and space between the holiday description (subject) and the date. For example:

[United States] 3
Independence Day, 2012/07/04
Thanksgiving Day, 2012/11/27
Christmas Day, 2012/12/25

To create a custom set of holidays, you can create your own HOL file in notepad by following these steps. Tip: you can work with the dates in Excel, then copy and paste into Notepad to save as an HOL file.

  1. Open Notepad
  2. Enter a "county" header, in [country] format. For example, I might use [Slipstick Systems]
  3. On separate lines under the header, enter the events, one per line in
    Event subject, yyyy/mm/dd format.
  4. Save the file using the HOL extension.
  5. Double click on the file. If Outlook is not on top of the screen, switch to it.
  6. Select the location and click Add.

A version of the US-only holidays, split between Federal holidays and popular observances is available at Outlook Tips. Right click and save the file to your hard drive then double click to add them to Outlook's Calendar. If you previously added the US holidays, you'll have duplicates. Remove the duplicates by deleting the holidays in the United States location.

UK bank holidays has an *.ics file available for download. This will work with Outlook 2003 and newer, as well as with most other calendaring applications and services.

The Israel and Jewish holidays are in the HOL file using Hebrew calendar dates (i.e. Yom Haatzmaut,5773/8/6,8) and Outlook 2003 is not able to import them. Israel-2013-2020 is a Gregorian date version for Outlook 2002 and Outlook 2003. Jewish ICS for importing into

Fun with Holiday files: Countdown the days in a year

You can use a custom HOL file for any all day events you desire. In this example, we are going to add all day events to the calendar to countdown the days in a year, from 1 to 365 and include the number of days left in the year.

Do you need to know what day of the year today is or how many days are left until the end of the year? Although Outlook doesn't display these numbers, it's very easy to create a file counting the days using Excel and import it into your calendar.

The original suggestion came from "Alawishes". He suggested using a CSV containing the Subject, Date, and a Category then importing it.

Create a file with the Subject, Date, and a Category using Excel's fill series feature then save it as a CSV to Import into Outlook's Calendar. While a category is not required, it makes it easy to filter the events. Using this method, you can import the events to any calendar.

While his suggestion is a great idea and has certain advantages: you can choose your own category or import it into a different calendar folder, you could create a HOL file and save the Import step. In the CSV, use only the Subject and Date fields then save it and change the extension to HOL. Open the HOL in Notepad and change the line above the dates to a "location" and the number of items in the "location" group, in [location] 366 format. (The location name can be anything you like. )

Add holidays to Outlook's calendarUsers can double click on the HOL to open the Add Holidays dialog and add the dates to the default calendar. When you use this method the events will be added to the Holiday category.

To delete these Holidays, group, sort, or filter by Location field and delete the items for your location.

We have a sample HOL file at DayNumbers 2015. Note: You may need to right click on the link and use Save Target As (or Save Link As).
DayNumbers 2016 DayNumbers 2017 DayNumbers 2018

More Information

To remove duplicate holidays from the Calendar folder
US-only holidays, split between Federal holidays and popular observances is available here.
UK bank holidays
The Israel and Jewish holidays are in the HOL file using Hebrew calendar dates (i.e. Yom Haatzmaut,5773/8/6,8) and Outlook 2003 is not able to import them. Israel-2013-2020 is a Gregorian date version for Outlook 2002 and Outlook 2003. Jewish ICS for importing into


  1. John Katayama says

    This was very helpful with the information. Do you know how to make the holiday's show up as busy rather than a free appointment?

    • Diane Poremsky says

      You'll need to change them after importing. Add the Show time as field to a list view, group by Category then Show time as. If there are is not a busy group in the Holiday category, right click on one event and set it to busy. Now you can select all holidays and drag to the busy group.

  2. Judy Sheridan says

    Sorry, I should have said that the holidays are in my calendar but I want to add the religious holidays and I don't see the button to add holidays.

  3. Judy Sheridan says

    I downloaded the file and then when I accept the agreement (or whatever it is called) it says that the update is already on there. I put the update on in December but didn't check the box for the religious holidays so that's what I'm trying to add. I found the HOL file and deleted it and tried to download again but it still says the update is on there but no add holidays button.

  4. Judy Sheridan says

    Well you can ignore my last post. I deleted the file again and downloaded the file again today and lo and behold, the button is there. I don't know why that didn't work yesterday. Gremlins!

  5. bgrits5775 says

    I have Outlook 2010. Is there a way that the holiday is displayed but not the region? Example: Instead of May 12 displaying "Mother's Day; United States," I want it to display "Mother's Day" on my calendar. Thank you.

    • Diane Poremsky says

      You'd need to remove the location, which is easy enough - group by location and drag them to the (none) group.

  6. Irene M says

    I have successfully added the UK public/bank holidays to my calendar. I also have an additional calendar, but the holidays are not showing there. How can I copy them across?

    • Diane Poremsky says

      Switch the calendar with the holidays to a list view. Select the holidays you want to copy and right-click drag to the second calendar folder.

  7. bgrits5775 says

    I have calendar events grouped by location; however, I can't figure out "drag them to the (none) goup." I do not see "none." Can you break it down for me? Thank you

    • Diane Poremsky says

      Delete the location from one event. That should create a (none) group. Drag the others to the group. This tutorial shows how to drag contacts between groups to change values but its the same for appointments too.

    • Diane Poremsky says

      You should have an entry for Jewish Religious Holidays. (Christian and Islamic religious holidays also have their own 'locations'.)

  8. Bob says

    Can you tell us how to include the custom holiday file in our office 2010 deployment? How could we replace the default outlook.hol with our custom file so users get it during setup?

    • Diane Poremsky says

      It's been a while since I looked at creating a deployment... but you'd want to replace the outlook.hol file with the custom one.

  9. Mark says

    Thank you very much for the Add Holidays - not often you attempt something and it all goes seamlessly and at a busy time to boot.

  10. Angela says

    I have two Outlook Calendars that I have at work - one for myself and one that I have shared with my co-workers for vacation days. When I went through and added the holidays they showed up in my calendar, but they did not show up in the calendar that I share with the vacation days. Can anyone help me add the holidays to my second calendar? Thank you for any help that you can be!!

    • Diane Poremsky says

      To add holidays to your non-default calendar, you'll need to switch to a List view, group by category and select the holidays then move or copy to the other calendar.

  11. Nancee says

    Diane, You truly should be instructing the staff at Microsoft as your instructions are virtually infallible, and simplified to say the least. Many Thanks!

  12. Charlie says

    Hi, I went to "C:\Program Files\Microsoft Office\Office14\1033" but could not find a Outlook.HOL file. I am able to enter holidays by region or religion by going to "Options > Calendar Options > Add Holidays". I would like to create a custom holiday list.

    • Diane Poremsky says

      You don't need the HOL file for that - create a list in notepad, save it with the HOL extension then double click to run. All you need to do is make sure the count is correct next to the location and the event names and dates use the correct format.

  13. Jerry says

    I want to display Holidays - but without the Location. I already know all my holidays are for my country. Can I change the view to not display location?

  14. Wendy says

    Hi Diane
    I am trying to import a .hol file that was sent to me which should update my outlook calendar with specific sporting fixtures for our wrestling club. When I open the attachment I see Add Holidays to Calender with three options to tick. I chose the two options I want and enter, I get a message "Already installed, do you want to install again?" (I have tried numerous times), I say Yes. Then I get an error message "The holiday file contains errors or it is not in the correct format. Some holidays might not have been added to your calendar". In the background I see the action for a file transfer, but nothing is transferred. If I say OK to the error message or close it, the operation stops. If I leave it with the file transfer action happening in the background still nothing is transferred. This .hol file has been sent to a number of us at the club and I am the only one not able to import it successfully. Please help!

    • Diane PoremskyDiane Poremsky says

      I'm surprised it works for some and not you. Could the others be skipping one of the lists you are trying to add? What version of Outlook do you use?
      I know two things that will definitely cause issues: the wrong count of items at the top of a group and the wrong date format. You can open the Hol file in notepad and review it.

  15. Bev Miller says

    Is there any way to set a reminder for the items in the holiday file? (We're trying to use a holiday file to provide deadlines for people.)

    • Diane PoremskyDiane Poremsky says

      No, not as they are importing. You can set reminders on them later, but that won't help you.

Leave a Reply

Please post long or more complicated questions at OutlookForums by

If the Post Comment button disappears, press your Tab key.