Get location of match in another worksheet
 

"Workbook A/worksheet A" contains a reference cell with a date (formatted
date number). I need a formula for this worksheet that gives the cell
address in range B1:G65 of "workbook B/worksheet C" that matches the contents
of the reference cell. Some of the cells in B1:G65 of workbook B/worksheet C
contain date numbers and one will match. I will use that address to import
data from cells below the matching cell.