Formula Help Subtracting a Day

I have a networkdays formula that i need to have subtract 1 day because it is counting same day efforts as 1 day and i need it to count it as 0 days. How should i update my formula?


=IFERROR(NETWORKDAYS([Actual Start Date]@row, [Sub-Task Completion Date]@row), "")

Best Answer

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @dgloballab

    You can add -1 to the formula right after the first closing parentheses.

    =IFERROR(NETWORKDAYS([Actual Start Date]@row, [Sub-Task Completion Date]@row) - 1, "")

    Cheers,

    Genevieve

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

Answers

  • Genevieve P.
    Genevieve P. Employee
    Answer ✓

    Hi @dgloballab

    You can add -1 to the formula right after the first closing parentheses.

    =IFERROR(NETWORKDAYS([Actual Start Date]@row, [Sub-Task Completion Date]@row) - 1, "")

    Cheers,

    Genevieve

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!