NETWORKDAYS function help

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!!

Best Answers

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓

    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!


    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!


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

    W: | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!