Conditional Formatting Dates

[paulman1976]

I need to conditional format cells where a date is less than today but no longer than 6 days ago.

In conditional formatting, what formula do I use to achieve this?

 

[RCBricker]

try this formula in the conditional formatting

=AND(G7<TODAY(),G7>TODAY()-7)

change G7 to your cell address

 

[RCBricker]

I didn't check the post after posting.

=AND(G7 *less than symbol* today(), G7 *greater than symbol* today()-7)