Back to ArticlesBack

Subscribe to our newsletter

Get the latest articles and resources sent straight to your inbox.

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 500,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

© 2025 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••
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

Two Project Manager Agent Features You Might Like
Articles
5 min read

Two Project Manager Agent Features You Might Like

Discover two game-changing features of Microsoft’s Project Manager Agent including agent-to-agent communication and the new integrated interface in Planner.

E
Erik van Hurck
about 1 month ago
Read
Master Dependency Analysis in Microsoft Project with SSI Tools!
Articles
2 min read

Master Dependency Analysis in Microsoft Project with SSI Tools!

Learn how to master dependency analysis in Microsoft Project using SSI Tools’ Directional Path, Connecting Path, and Dependency Tracer to analyze predecessors, successors, and project logic.

K
Kenny Arnold
about 2 months ago
Read
A PM’s Halloween Survival Guide
Articles
5 min read

A PM’s Halloween Survival Guide

Discover the spooky parallels between Halloween and project management, from scope creep monsters to ghosted team members, in this fun survival guide for PMs.

R
Ronald B. Smith, MBA, PMP
2 months ago
Read
Explore All Articles