Forum Discussion
kanselmi
Dec 02, 2024Copper Contributor
Excel formatting based on difference between two dates/columns
Can anyone tell me how I would formulate the cell in comlumn BU to read "late" if the difference between the date in column A is greater than two weeks later than the date in column N? See example row of report below.
Thank you!
In AU2:
=IF(A2-N2>14, "Late", "")