Return Data From Last 7 Days

Hi all,

I am having a senior moment when trying to extract data from a table for the past 7 days.

In a sheet called 'Data', Column A has multiple dates (DATETIME format). The following columns (B,C,D etc.) contain other information that relate to these dates.

What I am trying to achieve is to extract all data from any rows from the 'Data' sheet into a sheet called 'Summary', but only showing data from the last 7 days.

Any help would be appreciated.

Many thanks in advance,

TM.

Thanks for the quick reply Tony.

I have attached the sheet to try and help explain myself better.

As you can see on the 'Data' sheet, I have a list of dates in column A.

On the 'Summary' sheet, I want to do a lookup from the data tab to only show entries from dates 7 days less than NOW(). I then want to return all other columns for dates that match the criteria.

As an example, there should only be 4 entries on the 'Summary' sheet, as only 4 rows from the 'Data' sheet are less than 7 days old (from today's date).

I just cannot figure out how to create the correct formula for this so that it automatically updates whenever the data changes.

I hope this makes a little more sense..

TM.

AlKey, that is exactly what I wanted!

How you came up with that, I have no idea. But thank you very much for your help with this.

TM.

Originally Posted by AlKey

Or maybe this
Enter array formula in C1

Formula:

Please Login or Register  to view this content.

***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

then enter formula in A4 and copy formula across and then down. Format Col A as Date/Time

Formula:

Please Login or Register  to view this content.

Please see attached file.

Sorry for the dead thread revival, but this is the only thing I've seen that actually solved my dilemma.

I tried using this on a spreadsheet I have. It is working for the most part, except it's returning 10/3/2018-10/15/2018 rather than 9/26/2018-10/3/2018.

Any idea why?

Originally Posted by AlKey

Or maybe this
Enter array formula in C1

Formula:

Please Login or Register  to view this content.

***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

then enter formula in A4 and copy formula across and then down. Format Col A as Date/Time

Formula:

Please Login or Register  to view this content.

Please see attached file.

Ok so I figured out why the dates weren't pulling right. My dummy sheet had dates past today's date.


Now I have it all working except for one problem. If there is any data in Column F on Sheet 1, I lose that row completely on Sheet 2.

Never mind. All dumb questions. I figured it out.