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

Copilot Researcher Model Selection: A Small Lever With Real Effect on Project Research
Articles
1 min read

Copilot Researcher Model Selection: A Small Lever With Real Effect on Project Research

MPUG Editorial · September 8, 2026 · ~4 min read · Category: AI & Copilot Copilot Researcher model selection arrived in the Microsoft 365 Copilot release notes dated 25 August 2026, and […]

A
Anonymous
about 7 hours ago
Read
Prompt Engineering for Project Managers
Articles
1 min read

Prompt Engineering for Project Managers

Treat AI prompts like project requirements, with three ready-to-use templates for risk analysis, executive updates, and change request tradeoffs.

A
Anonymous
1 day ago
Read
AI Agents in Jira Can Now Write, Not Just Read: Rovo A2A Goes GA
Articles
1 min read

AI Agents in Jira Can Now Write, Not Just Read: Rovo A2A Goes GA

MPUG Editorial · August 31, 2026 · ~5 min read · Category: AI & Copilot AI agents in Jira crossed a meaningful line this month. On 11 August 2026, Atlassian […]

A
Anonymous
6 days ago
Read
Explore All Articles