We have users that record issues into a system, and they need to enter the date the issue is created and then a due date-- the due date is supposed to be 3 business days from the created date. (Examples: created date is 10/6/2015, so the correct due date to enter would be 10/9/2015. If the created date was 10/9/2015, the correct due date would be 10/15/2015 because it would not count the 10th and 11th because those are weekend days, and it would also not count the 12th because that is a holiday.)
I have a conditional formatting rule set on the Due Date values using this formula:
=NETWORKDAYS(F4, G4, $L$3:$L$4)<>3 (my holidays are in the L3 and L4 cells)
I'm getting unexpected results. Anybody know what I'm doing wrong?
I've attached my spreadsheet-- I color-coded out to the left what I think should be correct and what should be flagged by the conditional formatting.
I have a conditional formatting rule set on the Due Date values using this formula:
=NETWORKDAYS(F4, G4, $L$3:$L$4)<>3 (my holidays are in the L3 and L4 cells)
I'm getting unexpected results. Anybody know what I'm doing wrong?
I've attached my spreadsheet-- I color-coded out to the left what I think should be correct and what should be flagged by the conditional formatting.