Outlook's Missing Holidays

Update 7/2012: Microsoft released an updated Holiday file for Outlook 2007. It contains the same holiday list I have here.

See the note below to avoid duplicate holidays.

The Holiday file downloads at the end of this article contains holidays for through 2020, for Outlook 2002 and up.

A version of the US-only holidays, split between Federal holidays and popular observances is available here. 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.

Tariq Khalaf Shared a link to UK bank holidays. The site 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 Outlook.com

Each version of Outlook includes holidays you can add to your calendar by going to Tools, Options, Calendar options, Holidays. Select the country (or countries) that has the holidays you want on your calendar and import. If you use a version of Outlook longer than 3 years or so, you'll need to find an alternate source for holidays. If you upgrade to the newest version of Outlook, go to Tools, Options, Calendar and Add Holidays again to get the newest holidays list installed. Click Yes when asked if you want to install the holidays again. In Outlook 2010 or Outlook 2013, go to File, Option, Calendar to find Add Holidays.

VersionHolidays supplied through the end of
Outlook 20002003
Outlook 20022005
Outlook 20032007
Outlook 20072012
Outlook 20102020 for movable dates such as Easter and Mother's Day; 2028 for fixed holidays such as New Years Eve and Valentine's Day
Outlook 20132022 for movable dates such as Easter and Mother's Day; 2031 for some fixed holidays such as New Years Eve and Valentine's Day

When you upgrade to a newer version of Outlook you can use Add Holidays to update your calendar with the new holiday list. If you wish, you can use a Category view and delete the events in the Holiday category before using Add Holidays. This is not required, but doing so eliminates possible duplicates of older holidays.

You may receive a warning that the holidays are already installed. You can ignore this warning (and click Yes) if you are installing the holidays in an upgraded version of Outlook and don't have holidays for "this year" in your calendar.

Install Holidays dialog

Deleting the events in the Holiday category before importing holidays will eliminate this message.

For Outlook 2000 and earlier versions, the list of holidays is stored in a text file named Outlook.txt, found in the language specific subfolders of the Office folder. Starting with Outlook 2002, the file is named Outlook.hol. You can edit this file using notepad or create your own holiday list.

The holiday list is in the format of [country or company name] # of lines of holidays, followed by one line per holiday, in the format of Holiday name (Subject),yyyy/m/d, as shown below. Save the file as Outlook.hol (or outlook.txt if you use Outlook 2000 or earlier), place it in the proper folder and import it from Tools Options, Calendar options, Add Holidays.

Note: You don't need to put the Outlook.HOL in "the proper folder" to use it. You can double click on it from any folder (or an email attachment) to open the Add Holidays dialog. It only needs to be in the folder if users will be going through Options, Calendar Options. The text file needed for Outlook 2000 and earlier does need to be in the proper folder.

[United States] 120
Administrative Professionals Day,2003/4/23
Administrative Professionals Day,2004/4/21
Administrative Professionals Day,2005/4/27
Administrative Professionals Day,2006/4/26
Administrative Professionals Day,2007/4/25
Christmas Day,2003/12/25
Christmas Day,2004/12/25
Christmas Day,2005/12/25
Christmas Day,2006/12/25
Christmas Day,2007/12/25

If you don't want to create your own holiday file, you can download a holiday file from several Internet sites, such as Calendar Updates. There you'll find Holidays, your favorite sports team schedule, and other useful calendar appointments. (Next year's holidays will be available near the end of this year.)

Note: You will have duplicates for 2012 and earlier if holidays for those years were previously added. Use the By Category view and delete the items in the Holiday category before importing to eliminate duplicates.

Holiday Files:

Outlook Holiday file with dates through 2020/2028 – for Outlook 2002, 2003, 2007, 2010 (has corrected Easter Monday). Choose Run or Save then double click on this file to bring up the Add Holidays dialog.

You can replace your Outlook.HOL file with this one. Look for it in your Program Files Office [language id] folder then install the holidays using Tools, Options, Calendar Options, Add Holidays.

This holiday file adds floating dates (such as Easter) through 2020 and holidays that don't move, such as Christmas and New Years, through 2028.

Outlook 2000: An updated CSV file containing Jewish Holidays for 2013 – 2020 is available. It contains the same holidays as in the Outlook 2010 Holiday list, but in a format that can be imported into Outlook 2000.

To reduce confusion and keep the old files accessible for the users who need the old dates, the are now on Page 2.

Links

Slipstick's Holiday Issues Included on this page is a "Days of the Year" HOL file that counts down the days left in the year, using "Day 1: 364 to go" format. Updated for 2013.

Outlook 2010 has incorrect holidays for UK and many other countries – Adam Vero

Last reviewed on November 4, 2013.

  • Doug Collins

    I'm trying to add holidays in 2013 and beyond to Outlook 2007.

    When I clock on your file "Outlook Holiday file with dates through 2020/2028," I opens into a list of dates without giving me the option to save it or to run it.

    Is there a problem with the current version of the file, or am I doing something wrong?

    Please advise.

    Thanks for your help.

    Doug Collins
    Hermosa Beach, California

  • http://www.outlook-tips.net Diane Poremsky

    Are you using Firefox? Right click on it and choose Save link as... to save it.

  • Texalana

    I was having the same problem as Doug. I tried your solution, Diane. It worked for me. Thank you!

  • Lynette

    The "Outlook Holiday file with dates through 2020/2028 – for Outlook 2002, 2003, 2007, 2010 (has corrected Easter Monday" link is giving me an error message when clicked.

    Thanks for your help.

  • http://www.outlook-tips.net Diane Poremsky

    Thanks for letting me know. It should be fixed now. Holidays for 2006 through 2012

  • Leon VanWie

    The fifth time I tried it - it worked. Sorry to be a bother.

  • Harry Gordon

    I'm using Firefox - I am trying to update my Outlook 2007 calendar with future holidays.

    I downloaded the OUTLOOK.HOL file, replaced the original one with the new one and then attempted to add the holidays using the ADD HOLIDAYS option within the Outlook Calendar.

    However as soon as I click on the ADD HOLIDAYS button, I get an error message that the file cannot be opened that it might be damaged.

    Thank you for any help you might be able to offer.

    Harry G.

  • http://www.outlook-tips.net Diane Poremsky

    @Leon: Not a bother at all - it looks like the URL is wrong. The correct URL is http://www.outlook-tips.net/files/OUTLOOK.HOL

  • Harry Gordon

    Thank you, Diane. The new link worked like a charm. Appreciate your help. Have a wonderful week.

    Harry G.

  • http://www.outlook-tips.net Diane Poremsky

    @Harry - right click on the link and choose Save Link as then double click to open it after it downloads. This will bring up the dialog (possible behind other windows, so bring outlook into focus after double clicking on the HOL file and it *should* work ok. (It did when i double checked it here.)

  • DeAn Blanton

    I want to automatically make the Holiday's SHOW AS show as OUT OF OFFICE - any suggestions

  • http://www.outlook-tips.net Diane Poremsky

    This is not possible when you import the holidays using the HOL file. If you import from a spreadsheet, you can set the Show time as flag. You can bulk change events by adding the show time as field to a List view and grouping by it, then setting one event to OOF. Drag the items you want mark OOF to the OOF group.

  • http://mportal.com Marcia

    I have made a custom list of Holidays to distribute to people in our office. It works on a PC, but what about a MAC? How can I create a file that will work on a MAC? I asked someone in the office to try adding the custom holidays using the file I had created on my PC, but he was unable to open it on his MAC.

  • http://www.outlook-tips.net Diane Poremsky

    If you are using a HOL file, it won't work on a mac. I'll have to check on what format macs use.

  • Dwaine

    I can't get the Outlook Holidays through 20202028 for Outlook 2007 to work. I save the file, open it, click on the add holidays dialog, and no holidays get added after 2012. Help?

  • http://www.outlook-tips.net Diane Poremsky

    Are you using this link? http://www.outlook-tips.net/files/OUTLOOK.HOL

    Open the file in Notepad and see if the dates are through 2028.

  • David Cahill

    I need to up date the calendar in Outlook 2003 past 2011.
    Is this possible and if so how do I achieve it.
    Any assistance appreciated.
    Cheers,
    Dave.

  • http://www.outlook-tips.net Diane Poremsky

    You'll use the Outlook 2010 version - download it and double click to open the Add holidays dialog. http://www.outlook-tips.net/files/OUTLOOK.HOL

  • Jon Walker

    I'm running OUTLOOK 2007 with VISTA, and I've looked in the PROGRAM FILES / MICROSOFT OFFICE and all the sub-folders to no avail!

    An "advanced search" didn't pull up a single occurance of the ".hol" file at all.

    Where has VISTA and OUTLOOK 2007 hidden this file?
    Jon

  • http://www.outlook-tips.net Diane Poremsky

    It should be in C:\Program Files\Microsoft Office\Office12\1033 (assuming English version). If you have a non-english version, it will be a different 4-digit folder under Office12. If you have extensions hidden, it will just say "Outlook" and in the Type column in Details view, it will say "Outlook Holidays".

    Your version has an older HOL file, ending with 2012 holidays. You don't need to replace it - you can download the updated version we have and double click to open the Add Holidays dialog. Select your locations and Add to complete the process.

  • VetToo

    I easily update my Outlook 2007 calendar. This was very helpful, thanks Diane. :)

  • Garry Edmunds

    great update for calendar dates only problem is that easter monday being put on the sunday otherwise seems to work fine thanks.
    garry

  • http://www.outlook-tips.net Diane Poremsky

    Oh, I thought I uploaded the corrected version after I learned about the problem with Easter Monday. Thanks for letting me know it needs fixed.

  • RB

    Thanks for making this available! It was exactly what I needed. :-)

  • A.N.Other

    UK Easter Holidays "Easter Monday,2013/3/31"
    I make that a Sunday..!

  • http://www.outlook-tips.net Diane Poremsky

    Thanks. It's fixed now. About half the countries that celebrate Easter had the correct dates, the other half did not.

  • Chi Lee

    I downloaded your "Outlook Holiday file with dates through 2020/2028" and other links for my Windows 7 and Outlook 2007 program. But each time, i only get the holidays for 2006 to 2012. I also looked into the file, that is all the dates are in your Outlook.hol file.
    Could you check if the link is properly directed to holidays beyond 2012 please. Thanks.

  • http://www.outlook-tips.net Diane Poremsky

    The links (one at the top of the page and the one at the bottom you reference) point to the file http://www.outlook-tips.net/files/OUTLOOK.HOL and it contains dates through 2020/2028. How did you try to install the holidays? My recommended method is to download the file then double click on it. This brings up the Add Holiday dialog using the correct list - otherwise you need to copy the file to the Office directory (overwriting the old HOL file) then go into options to open the dialog.
    Boxing Day,2009/12/26
    Boxing Day,2010/12/26
    Boxing Day,2011/12/26
    Boxing Day,2012/12/26
    [snip]
    Boxing Day,2027/12/26
    Boxing Day,2028/12/26

  • Michael Mitchell

    So helpful. Thank you.

  • David

    I don't understand the "TIP/NOTE" about how to avoid duplicating holidays in years 2012 and prior. I'm using Office 2007. Can anybody help me?

  • http://www.outlook-tips.net Diane Poremsky

    You can do one of two things: ignore duplicates for past dates or use a group by category view and delete the holiday category, then import the new dates. I have a video tutorial showing how to delete the old holidays before adding the new ones - Group by category to delete Holidays from Outlook

  • David

    THANKS for the help!

  • Chi Lee

    It worked well. Thank you, Diane.

  • Michele

    I've been looking all over the place for this! Thanks so much for posting it. Worked like a charm. :)

  • Angela

    The system showed that the holidays were downloaded and imported but I am unable to see them on my calendar. How can I fix this?

  • http://www.outlook-tips.net Diane Poremsky

    Did you double click on the HOL list to install them? This will bring up the Add Holiday dialog with the new HOL list. Do you have more than one calendar folder and are you looking in the default calendar?
    Switch to a list view and verify if the current holidays are installed.

  • Rhonda

    Thanks! Looks like it worked and it was very easy.

  • seymour

    This is great thanks for doing this

  • heinz

    Great help, thanks. Heinz

  • Richard Herbert

    Is anybody here aware of a major problem with the Outlook.hol shipped with the French version of Office 2010? In particular, some Jewish holiday names are munged with Vietnamese characters and are unreadable (unless you can read Vietnamese, that is).

  • http://www.outlook-tips.net Diane Poremsky

    I was not aware of that. Are the characters messed up if you open the HOL file in notepad?

  • Richard Herbert

    Hi, Diane. Yes, the characters are messed up in Notepad. The names of the holidays are truly in Vietnamese, and contain high-byte characters. I asked someone from another office to send me his copy of the OUTLOOK.HOL file for French Office 2010, and his has the same problem as ours, so I consider it a Microsoft problem. Sorry for the delay in replying; I'll check back more often. Or you can e-mail me at rherbert at degrandpre dot com. Thanks!

  • Richard Herbert

    I found the smoking gun. It's the fault of Microsoft's translation engine :

    http://www.microsoft.com/language/en-us/Search.aspx?sString=Sukkot&langID=fr-fr

  • http://www.outlook-tips.net Diane Poremsky

    I will check on it.

  • Kathleen Kelly

    Diane, thanks so much for sharing, greatly appreciated!

  • http://www.outlook-tips.net Diane Poremsky

    @Richard Herbert - I talked to my contact in support and they repro'd the error. It is unlikely to be fixed before SP2, however if you need a fix sooner, you can open a support case and request a hotfix.

  • Rob Paz

    I'm using SCCM 2007 to deploy this patch using the following command line:

    office-kb2687329-fullfile-x86-en-us.exe /quiet /passive /norestart

    And the client is reporting the following error on install: The exit code is 17031

    Is there another way to deploy this patch?

    Thanks in advance! Rob

  • http://www.outlook-tips.net Diane Poremsky

    That code means the wrong version of Outlook is installed - you don't meet the prerequisites.

    The hotfix installs the updated HOL file to the Office folder, replacing the outdated HOL file. It annoys me to no end that they do a version check for it as the HOL file will work with Outlook 2002 and up.

    You can use a log on script and a current HOL file to do the same thing. Plus, new holidays can be installed by double clicking on the HOL file to start the Add Holidays wizard. For this reason, I'd probably replace the HOL in the office directory and drop the HOL or a shortcut on the desktop for users to run, so they don't have to go into options to add the new holidays to their calendar. You can get a new HOL file from here, from Outlook 2010 or 2013 installs, or using uniextract to expand the patch.

  • Rob Paz

    @Diane - Outlook 2007 (12.0.6550.5001) SP2 MSO (12.0.6245.1000) is installed (part of MS Office Professional Plus 2007.

  • http://www.outlook-tips.net Diane Poremsky

    It should work with SP2 - "You must have 2007 Microsoft Office suite Service Pack 2 or 2007 Microsoft Office suite Service Pack 3 installed to apply this hotfix package." - although I thought the initial article said SP3. I could be mistaken though.

  • David

    I have two calendars. The Holiday update loads into one of the calendars. How do I get the Holiday update to load into the other calendar?
    Thanks & Happy New Year!

  • http://www.outlook-tips.net Diane Poremsky

    Switch the calendar where the holidays are to a list view then group by category. Select the Holiday category and copy them to the other calendar. I have a little tutorial here - add holidays to a second calendar

  • S. Watford

    thank you

  • Jeff Olson

    Thank you so much! Very helpful for us old-school Outlook users.

  • http://www.facebook.com/tariqkhalaf Tariq Khalaf

    hello
    here is a list for people in the UK
    https://www.gov.uk/bank-holidays

  • Elisha Blatt

    I've been trying to use the HOL file provided here to add Israel & Jewish holidays to my Outlook 2003 calendar. The problem is that some of the holidays in the file have the Hebrew calendar format and Outlook is not able to import them ( i.e. Yom Haatzmaut,5773/8/6,8 )
    Can you please advise?
    Thanks,

  • http://www.outlook-tips.net Diane Poremsky

    I created a CSV file containing the Israel and Jewish holidays, as it's needed for older versions of Outlook too. Israel-2013-2020.CSV.

  • http://www.outlook-tips.net Diane Poremsky

    I may have uploaded a CSV containing older holidays earlier today. I corrected the CSV and also created an HOL file that should work with 2002 and up.

  • Monica Rose

    THANK YOU SO MUCH!!! Added the US-only holidays with the link above. Made my morning!

  • Gareth Soloman

    Diane, great little video on deleting old holiday dates and easy to follow instructions on firefox specific download procedure and file use! Thanx! BTW: France seems to have only Easter Mondays .... nothing for Good Friday or Easter Sunday .... or did I miss a "trick"?

  • http://www.outlook-tips.net Diane Poremsky

    I just imported France and have all 3 (with France location) - the list I imported from is from Outlook 2013 - I'll check the list i have online - You are right, no Easter/Good Friday. I'll upload a new list. (US has Easter but not Good Friday or Easter Monday - those are in the christian holiday.)

  • http://www.outlook-tips.net Diane Poremsky

    Never mind... Easter & Good Friday are in the France list. I didn't look down the list far enough (they are not in alphabetical order.) I realized it when the 2013 file I uploaded was the same KB size with the same number of holidays in France.

  • Michael

    I was trying to import the Jewish Religious Holidays for a friend into Outlook 2010. I ran through the import procedure, and the holidays were showing up during the import process with a bar graph, but when I went to the calendar, none of the imported holidays are there. I also noticed that the Jewish religious holidays in the "hol" file have years such as 5773, 5774, etc, rather than 2012, 2013, etc.. I don't know what that's about. Any help would be appreciated.

  • http://www.outlook-tips.net Diane Poremsky

    The Jewish holidays use the Hebrew calendar, which outlook 2007 and above should be able to convert to Gregorian dates. If it's not working, you can use the Jewish HOL file I added for Outlook 2003 and 2002 users.

    Did you look at the calendar in list view and group by categories? That's the best way to find out what happened to them. Also, if you have more than 1 calendar, check the other calendars - Add Holidays adds them to the default calendar in the profile.

  • Michael

    I did look in category view, and didn't find them. This person has iCloud which creates its own calendars and contacts within Outlook, so I thought perhaps they went into the regular Outlook calendar, but did not see them there either. I'll try the Jewish HOL file for OL 2003 and 2002. Thanks, Diane!

  • http://www.outlook-tips.net Diane Poremsky

    They would be added to the default Outlook calendar, which should be the one in an Outlook pst file. If Icloud2 is set as default, I'm not sure where Outlook will put them, I'll test it next.

  • Michael

    Diane, I don't see a separate holiday file for Outlook 2003 and 2002 users. Thanks for all your help.

  • http://www.outlook-tips.net Diane Poremsky

    Outlook 2002 and up all use the same HOL, except for Jewish holidays in Hebrew calendar format.
    http://www.outlook-tips.net/files/OUTLOOK.HOL

  • Michael

    That's the file I tried. iCloud is probably causing the problem then. Thanks, Diane!

  • Dee

    It added the 2013 holidays, but also duplicated holidays in 2012 and before. How can I delete the duplicate holidays from 2012 and prior? Thank you.

  • http://www.outlook-tips.net Diane Poremsky

    Switch to a list view and Group by Category, sort by start date. Select the oldest in the holiday category, hold Shift and use the Page Down key to select the old events, use arrow keys to fine tune the selection, then Delete.

    If you only want to remove duplicates but keep old holidays, sort by Modified date, delete all of the newly added events and then delete the 2012 events. Re-add the holidays.

  • Kathleen murphy

    Thank you, it worked for me!

  • weeshus

    Hi, I think I have read through all the posts and I don't think this question has been asked. My problem is that I have downloaded the .HQL file but I can not open it. Further investigation shows that there is not an "original" OUTLOOK.HQL file on my computer. I am using W7 Ultimate on a DELL XPS 15 8M RAM & 750G HD. My version of Outlook is 2003 Pro. Why? Because I juat hate the newer versions!

  • weeshus

    My sincere apologies for bothering you. With age comes bad eyesight - so misreading an "O" for a "Q" is not unknown!! Now I will play with the OUTLOOK.HOL file Regards and emarrassing apologies - Weeshus

  • http://www.outlook-tips.net Diane Poremsky

    Oh, if only everyone's problems were this easy to solve. :)

  • Nancy

    Worked great. Thanks!

  • Ron Sieloff

    I am running Office 2003 - Thank You Diane - the update worked perfectly

  • Richard

    I have Outlook 2002 and have written a fix to add UK hols and events up to and including 2017. If anybody's interested i'll post it here, if allowed.

  • Ronnie

    I am running Outlook 2003 and downloaded http://www.outlook-tips.net/files/OUTLOOK.HOL
    When I double clicked on it , it would not open the file. Can you help me to get the holiday calendar dates past 2012? Thanks!

  • http://www.outlook-tips.net Diane Poremsky

    You can post a link if you have it on a web server or you can email it to me @ diane@slipstick.com and I'll upload it here.

  • http://www.outlook-tips.net Diane Poremsky

    No errors or any message? Did you try downloading it again? It worked here - on Outlook 2003/WinXP with IE6 - so there is nothing wrong with the file itself.

  • Sheryl M

    Thank you!!!! worked great :)

  • Robert McKay

    I cannot believe we have succumbed to accepting the burden of fixing Microsoft's mistakes/oversights and lack of quality control. Why are so many willing to accept Microsoft's poor support in this and many other areas. As a user who paid a premium price for a premium product, I do not want to become a technician and have to parse though all of this "fix" mumbo-jumbo and risk doing even more damage resulting in even more work. I simply want a product that works. If it doesn't, then Microsoft should fix it seamlessly.

  • http://www.outlook-tips.net Diane Poremsky

    In most cases, someone missing holidays is not because Microsoft made a mistake. They provided 3 - 5 years of holidays in earlier versions of Outlook (more years in later versions). There is nothing to parse and any "damage" is minimal (duplicate holidays) - you repeat the same steps you used to add holidays the first time you set up outlook.

  • http://www.polyht.com Carlos Gonzalez

    Thank you very much for making the Holiday file available. I tried the Hotfix file from microsoft, but I got two different kinds of errors (40 and 110 to be exact) when trying to run the "blessed" file.
    Clicking on your link to the Holiday file worked perfectly.
    http://www.outlook-tips.net/files/OUTLOOK.HOL
    Many thanks!

  • Peter Stoll

    Hi Diane,

    I'm trying to add in Jewish holidays, I'm not sure what version of Outlook Calendar I'm using, it's on the web, I guess it's 2013? I found a website with a .csv file to download, but I've tried several times and keep getting an error message that there's a problem with my .ics file...I live in Canada, have all the other holidays fine. Can you help?

    Thanks!

    Peter Stoll

  • http://www.outlook-tips.net Diane Poremsky

    If you have Outlook 2013, the Jewish holidays in the HOL file will work. File, Options, Calendar - click the Add Holidays button then select the Jewish holidays. If you have a really old version, then you'll need the jewish holiday file. Save it, then double click to open the Add Holidays dialog.

  • Peter

    Thanks for responding; where do I find the "file" menu? This is what perplexes me about this web calendar; I only see New, Import and Share at the top left and icons for chatting, options and my profile to the upper right. Options doesn't seem to have a file section either...thanks!

    Peter

  • http://www.outlook-tips.net Diane Poremsky

    Oh. You are using Outlook.com in a browser? You need to Import a csv file. I can convert it to csv in the morning.

  • Peter

    Oh, that would be great! I've tried importing a .csv file I found here: http://www.hebcal.com but I kept getting an error message; I'm guessing it's the difference between having Outlook installed on my computer, and using the online version? Any help is gratefully appreciated!

  • http://www.outlook-tips.net Diane Poremsky

    Try this one: http://www.outlook-tips.net/files/jewishcalendar.ics - it worked when i imported it into my outlook.com calendar.

  • Peter

    Success! Thank you so much Diane!!

  • Roger

    Thanks, works beautifully. I couldn't find any Outlook holidays for Outlook 2003 that went beyond 2014. Thank you!

  • Diane (yes same as yours)

    Diane, thank you so much for this download with extended calendar to 2022 for My MS Office Pro 2007 Outlook calendar software. It worked perfectly the first time.