I am using the following formula to calculate workdays over due.
G6 has the issue identification date
H6 has the formula =workday(g6,5) which is the target date
I6 has the issue closed date
J6 has the formula =IF(ISBLANK(I6),NETWORKDAYS(H6,TODAY()),NETWORKDAYS(H6,I6)-1)
Since I am...