Exclude weekends/holidays in project schedule

[Jhoops]

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.

[#2]

@Jhoops 

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

you can also exclude your holidays too along with weekends.  

[#3]

@Jhoops 

Please check this https://exceljet.net/excel-functions/excel-workday-function