Network Days count off (as well as showing blank for no entry)

Options

Hello (searched and couldn't find), Thank you in advance for support.

Typical "Start Date" and "Actual End Date" columns. Having an issue with days in between not lining up correctly.

3/16/22 through 3/16/22 should equal "0" however shows "1"

3/16/22 through 3/17/22 shows 1

Every time i try to manipulate the number it doesn't align to one another.

Currently Using:

=IFERROR(NETWORKDAYS([Start Date]@row, [Actual End Date]@row) - IF(AND([Start Date]@row <> "", [Start Date]@row = [Actual End Date]@row), -1) - 1, "")

PS: I am also using blanks for no entry in both fields (which works)

Thank you

Answers

  • kelele20
    Options

    I had a similar issue. i resolved it with:

    =IF([Date Delivered]@row >= [Due Date]@row, NETWORKDAYS([Due Date]@row, [Date Delivered]@row) - 1, NETWORKDAYS([Due Date]@row, [Date Delivered]@row))


    Due date - Start Date

    Date delivered - End date

  • Morris R
    Morris R ✭✭✭✭
    Options

    Hello - Thank you,

    =IF([Actual End Date]@row >= [Start Date]@row, NETWORKDAYS([Start Date]@row, [Actual End Date]@row) - 1, NETWORKDAYS([Start Date]@row, [Actual End Date]@row))

    Worked for for some days but not for others which is odd.

    Also the BLANK days showing "invalid data type"

    3/16/22 through 3/16/22 = zero (great)

    3/16/22 through 3/17/22 = 1 (great)

    3/16/22 through 3/18/22 = 2 (great)

    3/16/22 through 3/19/22 = 2 (not sure why this didn't change

    3/16/22 through 3/20/22 = 2 (not sure why this didn't change)

    3/16/22 through 3/21/22 = 2 (not sure why this didn't change)

    3/16/22 through 3/22/22 = 4 (not sure why this didn't change)

    3/16/22 through 3/23/22 = 5 (not sure why this didn't change)


    Thank you for reviewing - maybe I missed something prior to morning coffee. :)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!