Not sure if I have the title right. Here's what I'm looking for.

Columns A to G contains days of the week formatted to show only the DD. Column H is the week number and may not follow standard convention. I need to input a date in Column I and have it look up the date in columns A to G and then return the week # from Column H into Column J.

Index/Match formula as I know it is limited to indexing a range, then matching to a column in that range. Need a formula to search the entire range - A2 to G54 (or so) and return the week # from Column H.

M T W T F S S Wk# Input Date Wk# (result)
30 31 01 02 03 04 05 1 01/08/14 2
06 07 08 09 10 11 12 2

Thoughts?