Dates for Today and Today +7 conditional formatting

[nutshellml]

You guys helped me out last time and now at another sticking point. I'm looking to highlight excel columns for appointments that happen today and anytime in the next 7 days, but having some trouble.

I tried: =$A2>=TODAY()+7 and it formatted all of the dates 7 days from today forward, leaving the dates that are within the (week) 7 days blank.

So I thought, let me just invert the formula: =$A2<=TODAY()-7 and nothing was formatted.

I know I'm missing something in the formula to show I want it GREATER than TODAY AND less than 7 DAYS from TODAY

 

[FDibbins]

if you want to test for "within 7 days from today"...
=and($A2>=today(),$A2<=today()+7)

 

[nutshellml]

GOT IT AGAIN: =AND($A2<=TODAY()+7,$A2>=TODAY())

I don't understand why the $A2<=TODAY()+7 needs to go before $A2>=TODAY(). If i reverse it, the formula won't work... go figure..

 

[FDibbins]

I just tested the formula again, and it didn't matter which way round I put the criteria, it worked OK both ways
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][/tr]
[tr][td]

2​

[/td][td]

10/22/2017​

[/td][td]

TRUE​

[/td][td]AND($A2>=TODAY(),$A2<=TODAY()+7)[/td][/tr]

[tr][td]

3​

[/td][td]

10/22/2017​

[/td][td]

TRUE​

[/td][td]AND($A3<=TODAY()+7,A3>=TODAY())[/td][/tr]
[/table]