Working on creating schedule variance icons, I am running across an issue which might be solved with absolute values of NETWORKDAYS but wanted to understand how to better structure the formula correctly. In this example I have two helper check columns Delta Check 1 and Delta Check 2 provided below. The problem I'm having is the +1 day being added to the differences in dates. I do not want to count the start date and to accurately reflect this need, I end up having to use two formulas instead of one column formula.
Screen shot above is using two different formulas, one for the past event and one for the future event for delta check 1. Using either the Past Event or the Future Event formulas shown below will incorrectly display date sums.
Past Event: =NETWORKDAYS(TODAY() - 1, [Start Date]@row)
Future Event: =NETWORKDAYS(TODAY(), [Start Date]@row) - 1
Control highlighted in blue was my original column formula: =NETWORKDAYS(TODAY(), [Start Date]@row)
For reference the TODAY() date is 2/26/21