Formula for Date Comparison

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,




I am looking for a formula that will compare two columns with dates. It would be column F and Column I. I would like Column I to change colors when it is 3 days after column F. Would anyone be able to help me out on this one?

Thank You.

Erin

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
for date simple subtraction would work

like
=I2>f2+3