Help With Remaining Work Days Formula


I'm in need of a formula that calculates remaining work days within a "start date" and an "end date".

I came up with this: =IF(ISERROR(NETWORKDAYS(TODAY(), [Start Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)) - which works fine as long as "today" currently falls within the "start date" and "end date".

But, I need it to account for start dates in the future. So, if my "start date" is 03/01/2024 and my "end date" is 02/29/2025, the above formula spits out "500" (but it should be 261).

Any help is appreciated.


Best Answer

  • Eric Law
    Eric Law ✭✭✭✭✭✭
    Answer ✓

    Hello @Nicole J ,

    I am a little confused about what you are trying to do. Can you give some examples? I THINK you can just use the following formula.

    =IF(Today()<[Start Date]@row, NETWORKDAYS([Start Date]@row, [End Date]@row), NETWORKDAYS(Today(), [End Date]@row))

    Hope this helps!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!