Conditional formatting based on 180 days out from today

[jharve01]

Hello

I am trying to set up conditional formatting that will look at the date in a cell, find out if that date is 180 out from today’s date. I tried to come at this a few ways “((a1-181)<Today())” I also tried “(a1<Today(-180))”. I was able to make this statement to work “=IF((AA3-TODAY()-181)<=1,"yes","No")” in another cell but can’t seem to get it to work in conditional formatting. Any help would be greatly appreciated.

Thank you
Joanna

 

[jharve01]

I'm sorry it looks like my post had an issue these are the formulas I have tried
(a1-181) < Today ( ) ) <today())< strong="">
I also tried
</today())<>( a1 < Today ( -180 ) ) <today())< strong=""><today(-180))< strong="">

The if statement “=IF((AA3-TODAY()-181)<=1,"yes","No")” I tried in a side cell to see if I could get a true statement.

Thank you
Joanna</today(-180))<></today())<>

 

[jharve01]

Never Mind. I continued to play with it and figured it out = AA3 < TODAY ( ) +180. I just had to rethink the logic.

Thank you
Joanna