Exclude weekends/holidays in project schedule

Copper Contributor

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.