Back to ArticlesBack

Join 50,000+ PM Professionals

Get expert PM insights, PMP prep tips, and earn PDUs with exclusive content delivered weekly.

Protected by reCAPTCHA: Privacy & Terms

MPUG - Master Project User GroupMPUG

A user asks: 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:

New Year’s Day January 1
Birthday of Martin Luther King 3rd Monday in January
President’s Day 3rd Monday in February
Memorial Day Last Monday in May
Independence DayJuly 4
Labor Day 1st Monday in September
Veterans Day November 11
Thanksgiving Day 4th Thursday in November
Christmas DayDecember 25

This full article is available only to MPUGpaidMembers.
Join today and read the article in its entirety today.

Get Weekly PM Insights

Join 50,000+ PMs receiving updates on the latest PM methodologies, PDU opportunities, tool reviews, career tips, and member exclusives.

Protected by reCAPTCHA: Privacy & Terms

PMI ATP
PMI Authorized Training Partner
REP #4082

Learning Paths

PMP® TrainingCAPM® TrainingPgMP® TrainingPMI-ACP® TrainingMS ProjectMS PlannerMS TeamsJira

PM Resources

PDU TrackerLive WebinarsSalary CalculatorTool ComparisonsJob BoardKnowledge BasePM GlossaryOur Faculty

Community

Discussion ForumStudy GroupsEvents Calendar

Follow Us

LinkedInYouTubeTwitterFacebook
MPUGMaster Project User Group

© 2026 MPUG. All rights reserved.

TermsPrivacySitemapAdvertise
Articles

Setting Recurring Non-working Time in Microsoft Office Project Standard 2007

A user asks: 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 […]

1 min read
•almost 18 years ago•Updated 8 months ago•
E
Ellen LehnertAuthor
Project Management
Microsoft Project
Best Practices
Productivity
E
Ellen Lehnert

Content Writer

Ellen Lehnert, PMP, Microsoft Project MVP, MCP, is a independent consultant and trainer on Microsoft Project and Project Server. She has taught Microsoft Project over 400 times and is the author of  MS Project 2010 and 2013 published courseware. Ellen is also a contributor and tech editor for many reference books, a developer for the Microsoft Project certification tests and is a frequent meeting speaker for Microsoft, MPUG and PMI. Contact Ellen at ellen@lehnertcs.com.

View all articles by Ellen Lehnert
Related Content

Continue Reading

Discover more insights and articles that complement your current reading

Asana AI Teammates Are Now Included in Paid Tiers — and Billed by Consumption After That
Articles
1 min read

Asana AI Teammates Are Now Included in Paid Tiers — and Billed by Consumption After That

MPUG Editorial · September 18, 2026 · ~4 min read · Category: PM Platforms From mid-September, Asana AI Teammates and the Dash assistant are included in the company’s paid Agentic […]

A
Anonymous
about 10 hours ago
Read
Teams Google Calendar Sync Retires in October 2026: What Project Managers Need to Do
Articles
1 min read

Teams Google Calendar Sync Retires in October 2026: What Project Managers Need to Do

MPUG Editorial · September 15, 2026 · ~4 min read · Category: Microsoft Tooling Microsoft is retiring Teams Google Calendar sync in October 2026, and if your program spans both […]

A
Anonymous
4 days ago
Read
Copilot in PowerPoint Live Now Explains Your Slides to Attendees
Articles
1 min read

Copilot in PowerPoint Live Now Explains Your Slides to Attendees

MPUG Editorial · September 7, 2026 · ~5 min read · Category: AI & Copilot Copilot in PowerPoint Live can now explain your slides to the people watching them. In […]

A
Anonymous
12 days ago
Read
Explore All Articles