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
Highlighted

@Jhoops 

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

you can also exclude your holidays too along with weekends.  

 

Related Conversations
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