A date in a cell greater than 10 days

[Infine]

Hello,

I try to put a condition:

I want if the date written in cell 02 is + 10 days I want to highlight it.

O2: 2021-12-28

Today it shall be colored.

If O2: 2021-01-07 I want it to be colored when we are in 2021-01-17


Anyone knows how I can do this? Google tell me: O2 < TODAY()-10 but this does not work... Especially as the value will be "2021-01-07" - 10 = 2020-12-28 which will highlight it.

 

[Infine]

Answer: =$O2>=(TODAY()+10)

 

[Infine]

Hello again,

The answer is: =$O2<=(TODAY()-10)

But I want an additional formula. I want that if "P2" is not empty, I want excel to ignore the rule above. Is this possible?

 

[Fluff]

How about

=AND($P2="",$O2<=(TODAY()-10))

this will only colour the cell if P2 is empty, if it should only work if p2 is not empty change ="" to <>""

 

[Infine]

<> worked. Thank you. I used =AND($O2<=(TODAY()-10);$O2<>"";($P2=""))=TRUE

 

[Fluff]

You're welcome & thanks for the feedback.