Monitoring Matrix.xlsx

Hi there

I need formula help. In column E I have a deadline date and in column F is the actual date the work was done. Column G calculates the difference between the dates to give whether in or out of timescales and red or green is then applied with conditional formatting. However, the issue is that all dates are counted therefore always one to0 many which impacts on the number in column G. Is there a way of adding to the formula in G which is =NETWORKDAYS(E5,F5,holidays) to discount one day? It is made more challenging by the fact that some deadlines are reached before deadline and others are not. As you can see, entries in F that are the same as in E are coming up with 1 not 0 and then flag red.

I hope you understand what I mean and can help!

Thanks