Microsoft Project Holiday Calendars 2020-2050 Available for Download

Are you already using the Holiday Calendar feature in MS Project? If you aren’t or you want to learn more about how to make your schedule more accurate, keep reading! The default “holiday calendar” in MS Project is called “Standard” (see Fig 1), and actually has no holidays in it (see Fig 2). If it did, it would look like Fig 3.

Figure 1: Default Project Creation

 

Figure 2: Default “Standard” Calendar

 

Figure 3: Example Holiday Calendar Entries

 

The official list of US Federal Holidays is provided here: Federal Holidays (opm.gov). There are 11, including the recent addition of Juneteenth. That’s more than two weeks’ worth of non-work days! If you aren’t using a holiday calendar in MS Project, your schedule could be off by two weeks at any given time. In addition to holidays, most staff take a day of vacation on the Friday after Thanksgiving, as well as take time off during the period between Christmas Day and New Year’s Day.

Given all this, the holiday calendar is error-prone and a pain to construct. Some holidays have a fixed-date which requires re-jiggering for the preceding Friday or succeeding Monday when such a holiday falls on a weekend. Other holidays have fixed days such as “the fourth Thursday in November.” This requires determining the actual date each year. There are 340 such calendar entries in the years spanning 2020-2050.

I’m a passionate believer in the holiday calendar. Newly-retired and motivated by the recent addition of Juneteenth, I attacked the construction and I’ve now created a “strict” calendar version that includes only the official federal holidays, as well as a “realistic” calendar version that also includes the Friday after Thanksgiving and the entire period from Christmas Eve through New Year’s Day. I recommend using the latter—no one will criticize you for avoiding scheduling events during Christmas break. Note that a holiday calendar does not prevent staff from working—it just avoids scheduling on certain dates.

You can obtain a template file containing both calendar versions from the website MSProjectHolidayCalendars.com. There is a $10 fee.  These calendars were auto-generated using custom code plus some manual editing, so they are quite reliable.  I’d love to hear from you in the comments below if you try it.

Next Webinar

The Missing Column

Jim Peter is a retired engineering planner with over three decades of experience in project planning and scheduling. He has a BS in Electrical Engineering, and MS in Computer Science, and an MS in Technical Management. He has written numerous custom VBA macros in MS Project. He is a native and resident of Baltimore. See the availability of MS Project Holiday Calendars here.
Share This Post
Have your say!
00

Leave a Reply