Excel conditional formatting comparing two columns of changing dates

[ernest-consultancy]

Help Please - I am looking for a formulae to compare two columns of dates.  e.g. Column A will be the start date and Column B the end date.  If column B is greater than column A by more than three days (ideally weekdays if that is also possible) then it will change colour.

[#2]

https://www.excel-easy.com/data-analysis/conditional-formatting.html

[#3 · Accepted solution]

Hello @ernest-consultancy,

Assuming your start date is in cell A2 and end date is in cell B2, then apply the following conditional format to cell B2:

=NETWORKDAYS(A2,B2)>3

[#4]

Many thanks that worked

[#5]

@ernest-consultancy 

You're welcome!