Counting dates in a range

Hi, I need to do a total of the dates entered in the RAW DATA sheet that fall in between todays date and 7 days ago. I am comparing it to B3 in sheet 2. Have tried a COUNTIF but cannot get it to work - any ideas

Try this:

=SUMPRODUCT(--(RAW_DATA!$E$2:$E$182<=A3);--(RAW_DATA!$E$2:$E$182>=B3))

Also replace <= and >= with < and > if you don't need dates written in table.

Also replace ; with , if you get error

If they need to be included then <= if not then <