Hello, I am trying to calculate the difference between multiple dates in one column, using the WORKDAYS formula. In the formula below, the difference between {Annual Completion Date} and {Annual Date} is correct but it is not pulling in the difference between {Q2 Completion Date} and {Q2}.
To calculate them, you need to include the MINUS function, like this:
MINUS(WORKDAYS({Annual completion date},{Annual due date},TRUE),WORKDAYS({Q2 completion date},{Q2},TRUE))
This will take the # of workdays between your annual completion date and your annual due date and subtract it from the # of workdays between your Q2 completion date and Q2 date.
The “TRUE” word in there will allow there to be negative values, I believe.