Conditional Formatting Help

[ddub25]

=AND($G4<=TODAY()-7)

The formula above is for Conditional Formatting. I'd like to adapt it to provide my formatting:

IF $A4 = NOT empty
IF the date in $G4 is between 1 and 7 days old

Can anyone help?

Dan

 

[Jonmo1]

Try

=AND($A4<>"",$G4>=TODAY()-7,$G4<=TODAY()-1)

 

[ddub25]

Thanks Jonmo, much appreciated.

Dan