Remaining workdays formula help


I am trying to figure out how to calculate the days until due and days past due and the formula I am using is not working - should it say 1 day left when today is the due date??

Best Answer

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    The NETWORKDAYS() function is date inclusive, meaning it will count both the start date and end date. This will result in 1 day if the due date is today. You can get around this by always subtracting one from the result:

    =NETWORKDAYS(TODAY(), [Due Date]@row) - 1


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!