NETWORKDAYS function help

Hannahsamd

I am creating a column that calculates the number of days between the "Finished Date" column and the "Needed By" column.

The original function was: =SUM([Finish Date]@row - [Needed By]@row)

We want to include only working days (M-F) and exclude holidays from this count of these days.

Sometimes the finished date rows will be blank because the project hasn't been finished, so we would want the new column to be blank instead of having an error.

Some help would be great!!

Andrée Starå

Hi @Hannahsamd

I hope you're well and safe!

Unfortunately, you would need to add one more column on the sheet or preferably on another sheet you can use with all the sheets as a reference.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

You would need another column somewhere. My suggestion would be on a separate sheet which you could then use for any other sheet you want to use the NETWORKDAYS function (or any other function that accounts for holidays). You can also use this sheet to house any other tables you may end up using to help keep references consolidated.

Paul Newcome

Try this:

=IFERROR(NETWORKDAYS([Finish Date]@row, [Needed By]@row), "")

Hannahsamd

I need holidays in it as well. I am wondering if there is a way to not have a holidays column in the sheet and the formula automatically take into account the holidays.

Paul Newcome

Unfortunately not. Some holidays are regional, so we have to specify which dates should considered as a holiday.

Hannahsamd

Do I have to make another column to specify each holiday?

Andrée Starå

Hi @Hannahsamd

I hope you're well and safe!

Unfortunately, you would need to add one more column on the sheet or preferably on another sheet you can use with all the sheets as a reference.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

You would need another column somewhere. My suggestion would be on a separate sheet which you could then use for any other sheet you want to use the NETWORKDAYS function (or any other function that accounts for holidays). You can also use this sheet to house any other tables you may end up using to help keep references consolidated.