Formula for Pulling Data - Help

[WarrenCarr]

Hello,

So I would like to be able to enter a date and have that weeks worth of data pulled into a location. See Image.

On the left hand side, there is the raw data with dates and info. I would like to be able to enter date into right hand side box and have the following 5 days auto populate below.

For example, I would enter "12/18/2017" then it would search for that date in the left hand side and return the next 5 days of data. (Image - https://ibb.co/e499Rn)

Any help would be appreciated. I am rather lost.

Thanks,
WC

 

[crazydragon84]

let me clarify what you are asking for. you have bunch of data (with some kind of date like transaction date) to the left. then on the right side you have an input date. based on that input date, you want to pull data from the table in the left with T+5 dates?

there may be a more sophisticated way but easiest way (without using vba and super complex formulas) that I can think of is:
1. OPTIONAL - Make the table to the left a table (Insert Table). Name the table
2. add a column to this table (call it calc date or whatever). put a formula there =if(AND(Transaction Date <= Input Date+5, Transaction Date>=Input Date), Input Date, "X")
4. Create a pivot table on the table. Make sure calc date is one of the fields, filter for calc date does not equal X.

Let me know if that helps.