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 da...
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
https://www.excel-easy.com/data-analysis/conditional-formatting.html