Returning a cell value in a spreadsheet not set up like a normal table

Hello,

Below is a made up spreadsheet to illustrate my problem. The initial design was not made by me and unfortunately cannot be changed. I am wanting to use functions or vba to return cell values if possible.

Here's how it works:
Each day an employee has a note located under the date and a letter code located to the right of the note. The letter code columns do not have headers.
In a separate sheet, I want to be able to enter the date and employee and have it return the corresponding note and letter code.
For example, if I enter: 6/14/2015 and Employee #1, I want the result to be "note1" and "r". Or if I enter 6/22/2015 & Employee #4 ---> "note3" and "m"

I thought the solution would be as simple as using HLOOKUP and MATCH for the note and some kind of OFFSET for the letter code, but it doesn't seem that simple.
The problem is there is no single row going across with all the different dates, and the employees down column A repeat every week.

I have tried various combinations of HLOOKUP, VLOOKUP, INDEX, MATCH, ADDRESS, INDIRECT, OFFSET, etc. but am completely stumped!

Anyone have any advice?

Thanks!
...........A.................B...........C........D..........E...........F...........G.............H..........I..........J..........K........L..........M............N
1........................Sunday............Monday..............Tuesday...............Wednesday..........Thursday..........Friday................Saturday
2........................6/14/2015........6/15/2015...........6/16/2015............6/17/2015............6/18/2015........6/19/2015...........6/20/2015
3... Employee #1...note1.........r
4... Employee #2...note2.........p
5... Employee #3
6... Employee #4
7... Employee #5
8... Employee #6
9... Notes
10........................Sunday.............Monday..............Tuesday...............Wednesday.........Thursday...........Friday................Saturday
11........................6/21/2015.........6/22/2015...........6/23/2015............6/24/2015...........6/25/2015.........6/26/2015...........6/27/2015
12...Employee #1
13...Employee #2
14...Employee #3
15...Employee #4...........................note3........m
16...Employee #5
17...Employee #6
18...Notes

Great, thanks!

Here's an example spreadsheet. I just randomly generated numbers for the note and have some random letters for the letter code.
I hope it attached right.

Calendar returning cell values.xls

Yes I know

Unfortunately, I didn't create the spreadsheet and I don't add new information to it either. The actual spreadsheet is in that same format and contains information about products extending back 3 years. The reason it is in that format is because other users often print out the calendar to get a quick glance at 4 or 5 weeks of past and future product notes.

I was just hoping to quickly pull information from it using lookup functions. Eventually the end goal was to be able to type a date range and "employee" and get a result of all the notes.

If there isn't a way to do it in the current format, I'll just have to copy all the data and reformat it to where I can use lookup functions, or just use Ctrl+F and/or scroll through to gather the information I need.

This works perfectly! I never would have come up with this.

I've spent about 30 mins just trying to understand how it works
It took me a while to realize the magic is that SUMPRODUCT turns the range into a true/false or 0,1 array multiplied by each row.

Anyway, this is awesome, thanks so much!