Extract data between two dates

Hello everyone!

I have spreadsheet with many columns. On the top of each column there is a date.
All dates are consecutive (not repeated). Each column consist data on daily basis.
I want to extract the data (included in 5th row for example) between two columns and show it on a trend.
Example: the numbers (data is numbers) from row 5 between columns with top cells: 1/10/2014 till 23/10/2014
First row of the table includes only dates.
This will be something like dashboard and is for comparison purpose.
Thank you in advance!

For clear picture, just upload your sample workbook, describe your desired results, click "Go Advanced" button and find paperclip button to upload your file.

Thanks

Azumi, thank You for the advise!
I have uploaded a sample and I have described inside my wishes.

Thank You

See attached file (second worksheet). As you'll see, I've highlighted the desired results you're after in green. These are updated automatically once you've selected the relevant 'data' required from the drop-down list in cell E6 (highlighted in yellow). This in turn also updates your graph accordingly.

Hope this helps.

Peter

Thank You very much Peter!
I think I understood even how the formula is working and in the future I will be able to use similar functions.
Actually this is the half of the "requirements" I have
Is it possible to use the date picker up for first and last date in the table?
Example: If I want to see same trends between 16/9/2014 till 25/9/2014
or from 21/9/2014 till 1/10/2014 for instance. I want to choose the period of time and to be able to change it.

I'll appreciate if you can just give me advise how to proceed and I will try to make it by my self.
But if this requires VBA, then it will be a task beyond my knowledge at all.

Thank You!

Hi

You'll see I've included a 'Date Picker' for the respective start and end dates in cells G6 and I6 (both filled in yellow) in the attached file (see second tab). The table filled in grey will generate the relevant values (for the tank no. selected from the drop-down list in cell E6) that corresponds to the start and end dates selected as well as those (if applicable) between these two dates, too.

I am not an expert in producing a dynamic chart that will expand or shrink to fit in with the 'start and end dates' range selected. (The example included in the file provided does cover this date range as well as that outside this range. Not ideal). But I see there are plently of info. on the web about how to create a dynamic chart if this is what you require? Alternatively you may want to ask others on this forum about how this can be achieved?

Thanks


Peter

Peter,

Excellent!

Formula you wrote is what I needed!

Thank You very much!

Kind Regards
Ognyan

Hi Ognyan

No problem. Glad I was able to help.

Thanks


Peter