Pull Data from Last Week Only?

How can I pull data from last week only regardless of today's date? I want the formula to be able to work in these situations below:

I.e.

1) Today is 11/20/2016, I want to pull data from previous week Sunday (11/13/16) to Saturday (11/19/2016)

2) If the date becomes 11/23/2016, I still want to pull the data from the same week range as above.

**I do not want to have the formula refer to 11/20/2016 as "last Sunday". I want to have 11/13/2016 instead.

3) If the date then is 11/27/2016, I want to pull the data from the previous week's Sunday (1/20/16) to Saturday (11/26/16)



Apparently this formula does not do the trick- for it is only for this week: =COUNTIFS('Feedback Data'!C:C,">="&(TODAY()-WEEKDAY(TODAY())+1),'Feedback Data'!C:C,"<="&(TODAY()-WEEKDAY(TODAY())+7),'Feedback Data'!$E:$E,A3)



Let me know how to write this...

I am hoping there is a simpler way. So far this is as good as I can come up with.

If you array enter this formula it will return 11/13/2016 until 11/27/2016. To get the last date in the week add 6 to results in another (adjacent?) cell.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

@ David A Coop

Try this small change to your formula.

Formula:

Please Login or Register  to view this content.

I experimented with it using a reference cell instead of TODAY.
It always returns Sunday of the previous week until the following Sunday ... meaning a new previous week.

The simple frequently eludes me.

You're welcome. Glad you found your solution. Thanks for the feedback and the rep.