Exclude weekends/holidays in project schedule

Question

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

kodipady · Answer

Jhoops&nbsp;You can use WORKDAY() to calculate dates and NETWORKDAYS() to calculate duration.&nbsp;&nbsp;you can also exclude your holidays too along with weekends.&nbsp;&nbsp;&nbsp;

sergeibaklan · Answer

Jhoops&nbsp;
Please check this&nbsp;https://exceljet.net/excel-functions/excel-workday-function

Forum Discussion

Exclude weekends/holidays in project schedule

2 Replies

Resources