Pull information based on week date falls under

In the attached file I have how much staff is available per week. I need to track this by day, but for my starting point, I want a formula that will look at the date in row 15 and pull the number in column D for the week that date falls in. Is this possible?

Nevermind, figured it out. Added a lookup to brink in the week based on the date and then a vlookup that brings in the staff