Hello all!

I am sure there is a simple solution to this that I'm over complicating. I need a formula that returns the number in the cell that corresponds to that days date. Basically, if today is 9/27/16, and my table looks like this:

9/8/16 9/22/16 10/6/16 10/20/16 11/3/16 11/17/16
Purple 8 11 14 17 20 23
Green 10 13 16 19 22 25
Yellow 12 15 18 21 24 27
Blue 14 17 20 23 26 29

I want my other chart to populate with the correct numbers based on the date ranges provided (for 9/27, the numbers would be from column 9/22, any date between 10/6 and 10/20 would return the numbers from 10/6, etc.):

Current Colors
Purple
Green
Yellow
Blue

Any help is appreciated!

Thank you,
Meg