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

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
5 days ago
Read
Three Things That Took the Longest in Real Project Online Migrations
Articles
1 min read

Three Things That Took the Longest in Real Project Online Migrations

Ira Brown debriefs a year of completed Project Online migrations, covering the reporting rewrite, single sign-on delays, and configuration work that took the most time.

A
Anonymous
6 days ago
Read
monday.com AI Workflows Now Pause for Human Approval
Articles
1 min read

monday.com AI Workflows Now Pause for Human Approval

MPUG Editorial · August 26, 2026 · ~4 min read · Category: PM Platforms monday.com AI Workflows can now stop mid-run and wait for a person to say yes. The […]

A
Anonymous
12 days ago
Read
Explore All Articles