Home

Exclude weekends/holidays in project schedule

%3CLINGO-SUB%20id%3D%22lingo-sub-803707%22%20slang%3D%22en-US%22%3EExclude%20weekends%2Fholidays%20in%20project%20schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803707%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%20-%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20fumble%20my%20way%20through%20a%20project%20timeline%20in%20excel.%26nbsp%3B%20See%20screenshot%20below.%26nbsp%3B%20I'm%20using%20a%20start%20date%2C%20plus%20a%20duration%20to%20create%20a%20schedule%20template.%26nbsp%3B%20How%20do%20I%20get%20it%20to%20recognize%20weekends%2Fholidays%3F%26nbsp%3B%20The%20threads%20I%20found%20in%20search%20seemed%20to%20be%20about%20counting%20days%20in%20a%20specific%20range.%26nbsp%3B%20Thank%20you%20in%20advance%20for%20the%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F126886i5C8BF9F68BADB688%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-803707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-803963%22%20slang%3D%22en-US%22%3ERe%3A%20Exclude%20weekends%2Fholidays%20in%20project%20schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-803963%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F391922%22%20target%3D%22_blank%22%3E%40Jhoops%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20WORKDAY()%20to%20calculate%20dates%20and%20NETWORKDAYS()%20to%20calculate%20duration.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20can%20also%20exclude%20your%20holidays%20too%20along%20with%20weekends.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-804150%22%20slang%3D%22en-US%22%3ERe%3A%20Exclude%20weekends%2Fholidays%20in%20project%20schedule%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-804150%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F391922%22%20target%3D%22_blank%22%3E%40Jhoops%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20this%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-workday-function%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%2Fexcel-functions%2Fexcel-workday-function%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Jhoops
Occasional Visitor

Hi All - 

 

I am trying to fumble my way through a project timeline in excel.  See screenshot below.  I'm using a start date, plus a duration to create a schedule template.  How do I get it to recognize weekends/holidays?  The threads I found in search seemed to be about counting days in a specific range.  Thank you in advance for the help.

 

clipboard_image_0.png

 

 

2 Replies

@Jhoops 

You can use WORKDAY() to calculate dates and NETWORKDAYS() to calculate duration.  

you can also exclude your holidays too along with weekends.  

 

Highlighted
Related Conversations
Device in Include and Exclude group
fatshark_2k in Microsoft Intune on
2 Replies
Problem when creating a recurrence pattern
Hienbh2203 in Project on
0 Replies
Project Timesheet Submission via Smart Phone hitting issues
Kurran in Project on
0 Replies
API access to the new Project Online
BenjaminMel in Project on
2 Replies
Problems Editting Enterprise Calendars
DeanS50 in Project on
3 Replies
Last Log In Activity on Microsoft Project?
Devryk in Project on
0 Replies