Forum Discussion
Solved
Excel conditional formatting comparing two columns of changing dates
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.
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 Replies
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
- Many thanks that worked
- https://www.excel-easy.com/data-analysis/conditional-formatting.html
