Question re Array Formulas to Check Date Ranges from multiple columns

First post here.

I have an issue which I suspect can be easily solved with array formulas.

Suppose Columns A through D have dates in them. Each column is approximately 15 days apart with A being first chronologically and D being last. I have about 500 rows of such dates.

What I want is a formula which can check, on a row by row basis, whether any of the dates in that particular row fall within a certain 7 day window. If one of those dates does fall within that 7 day window, I would like the formula to return the column number of the date which is in the window. Here's an example of what I'm talking about.


........A.......B.........C.........D.........E.........F
1.......Blue....Green.....Red.......Black.....7/22/13...7/29/13
2.......7/1/13..7/15/13...7/28/13...8/15/13
3.......8/1/13..8/15/13...8/30/13...9/15/13
4.......9/1/13..9/15/13...9/30/13...10/15/13
5.......3/1/13..3/15/13...3/30/13...4/15/13

Using this example, I would want to check in E2 to see if the dates in A2:D2 fell inside of the range from E1:F1. If one of the values does fall in that range, I want to return the name in row 1 of that column. For example, I would want the return on E2 to say "Red" because 7/28/13 (column 3 with header of "Red") falls in the range shown in E2:F2.