by Ellen Lehnert, PMP, MCT

An attender at the Sacramento chapter of MPA says: “I am fairly new to Microsoft Project. Is there a tool or resource out there that lists standard US holidays for the next 10 years as formulas that I can plug into Project? (For example, Thanksgiving is the fourth Thursday in November; Memorial Day is the last Monday in May...)

Along those same lines, what's the best way to have Project note that the Friday after Thanksgiving as a standing holiday too?

Answer: Regarding the standard list of US holidays, here you go, courtesy of Wikipedia:

Regarding plugging holidays into Project, the answer is “Yes” but only for Microsoft Project 2007 users. What you are asking about is a feature that was added to the 2007 version of the software. In 2003 and prior versions, you must click through the calendar and mark each day individually as non-working. In the 2007 version, the developers allowed for recurring non-working time. The option looks much like the recurring appointment function you find in Outlook. Here's how it works.

First, go to Tools | Change Working Time.

Figure 1: the Change Working Time screen.

In the Exceptions area I have entered “Thanksgiving”. and in the start and finish area I have entered the date of this year’s Thanksgiving. I am also ending the holiday on Friday because you are considering Friday a non-working day also. After this entry, select the Details button on the right. The Details for 'Thanksgiving' form will appear, as shown in Figure 2.

In the Details form, click on “Yearly”, click on the second option to say when the reoccurrence should start and change the number of reoccurrences to be 10 (or as many years as you need).

Figure 2: The Details page.

Click on OK and you are good to go. Repeat for as many holidays as necessary.

Note: The calendar you just completed is “living” in the project you created it in. To allow the calendar to be available to all of your other projects (so you don’t have to recreate it for each one), copy it through the Organizer to your Global.mpt template.

Do you have a question about Microsoft Project or project management? Submit it to ellen@lehnertcs.com.

Ellen Lehnert, PMP, MCT, runs LehnertCS, LLC, which specializes in Microsoft Office Project and Project Server training, consulting and installations. Customer industries have included technology, manufacturing, banking, construction, education, government and marketing. Contact Ellen at ellen@lehnertcs.com.