Back to ArticlesBack

Join 50,000+ PM Professionals

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

MPUG

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.

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 Glossary

Community

Discussion ForumStudy GroupsEvents Calendar

Follow Us

LinkedInYouTubeTwitterFacebook
MPUG Logo

© 2026 MPUG. All rights reserved.

TermsPrivacySitemap
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
•about 17 years ago•Updated 4 days 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

How Reserves Keep Projects Alive
Articles
4 min read

How Reserves Keep Projects Alive

Learn how project reserves protect your budget and schedule from unexpected risks, including when and how to use contingency, management, schedule, and cost reserves effectively.

R
Ronald B. Smith, MBA, PMP
about 8 hours ago
Read
Why Platform Migrations Fail (And How to Land Yours Successfully)
Articles
4 min read

Why Platform Migrations Fail (And How to Land Yours Successfully)

Learn why platform migrations fail and how to land yours successfully using proven change management tactics for PMOs facing tool transitions like Project Online’s retirement.

T
The MPUG Community
3 days ago
Read
Beyond Project Online: Why Now Is the Time to Plan Your Move to Modern Portfolio Management and How We Can Help
Articles
5 min read

Beyond Project Online: Why Now Is the Time to Plan Your Move to Modern Portfolio Management and How We Can Help

Microsoft Project Online retires September 2026. Learn why now is the time to plan your transition to modern portfolio management and join our free webinar on January 28.

T
The MPUG Community
14 days ago
Explore All Articles
Read