Originally Posted by Spencer101

Amend the same formula, to include it. You'd need to use AND for that.

=AND($A1=today()-6,F1<"Closed")

Change F to whichever column your "Closed" is recorded in if not F.

Hope that helps.