Extract data from between two dates

[ppidgursky]

Hello all,
I need you assistance once again.

I have a worksheet with a ton of data. It starts 1/1/17 and goes on throughout the year. Daily entries are made from two shifts so the dates duplicate and skip around due to days off or downtime. I want to be able to enter the date span and then have the data from specific cells from that span pulled and copied onto an new work book or sheet to be graphed.
I attached a sample workbook. The 1st sheet would is the year long sheet of data, the 2nd is what I would like. The third sheet is a sample I found online that works exactly how I would want my sheet to work. The only catch is it works vertically and I could not figure out how to go horizontally with it.

I have tried index and match, offset, sumif (which I came close with but because the duplicate dates it would add them together, where I need them separated). I am sure this can be done, I just haven't figured it out yet.
Any help would be great.

[bebo021999]

All the dates in sheet 1, Daily_Data, row 4, are not in unique format.
Try to use row 3 to convert into real date
C3:=IFERROR(DATE(RIGHT(C4,2)+2000,LOOKUP(12,LEFT(C4,{1,2})+0),LOOKUP(31,MID(C4,SEARCH("/",C4)+1,{1,2})+0)),C4+0)
Drag accross.

Then in sheet2, Chart_Data
B11:

Please Login or Register  to view this content.

Ctrl-shift-enter
Drag accross as far as needed
B12:

Please Login or Register  to view this content.

Ctrl-shift-enter
Drag down and accross

[ppidgursky]

This worked perfectly.
Thank you for your time.

[ppidgursky]

I would love to understand these formulas better. If you would, could you explain these to me so I may be able to apply these in future projects that come up? (i.e the small, mid etc.) Or at least guide me to literature that would help.

Thank you again.

[bebo021999]

I would love to understand these formulas better. If you would, could you explain these to me so I may be able to apply these in future projects that come up? (i.e the small, mid etc.) Or at least guide me to literature that would help.

Thank you again.

OK. Try to see the guidance in file attached.
Hope it is clear for you.