Days Remaining until Due Date (minus weekends)

I have a countdown to the due date column, but right now it includes weekends. I would like to have business days only.

My original formula was:

The formula I thought would work was this, but got a #invalid data type error:

Any suggestions? Thank you!

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    Hi @Caryn ,

    The NETWORKDAYS formula is slightly different than how you're trying to use it:


    So in this case you would want the section of the formula dealing with this to be:

    NETWORKDAYS(TODAY(),[Date Due]@row)

    If there are any extra holiday days, you can add these in a column (on another sheet if necessary) and then put to have the section of the formula more like this (using a column called "Holidays" in this example):

    NETWORKDAYS(TODAY(), [Due Date]@row, Holidays:Holidays)

    Hope this is of assistance!

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓

    Hi @Caryn ,

    The NETWORKDAYS formula is slightly different than how you're trying to use it:


    So in this case you would want the section of the formula dealing with this to be:

    NETWORKDAYS(TODAY(),[Date Due]@row)

    If there are any extra holiday days, you can add these in a column (on another sheet if necessary) and then put to have the section of the formula more like this (using a column called "Holidays" in this example):

    NETWORKDAYS(TODAY(), [Due Date]@row, Holidays:Holidays)

    Hope this is of assistance!

  • Thank you very much! It worked:


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!