Try this:
=COUNTIF(E:E,TODAY()+7)
Is that something you can work with?