Maybe there is a formula like -> Shipdate is between "before today" and 7 days from today? Maybe I have to use something other than Between