Date formula referencing another cell

[jmurphyamodeo]

I have a spreadsheet where I have dates in Column b and numbers in column F. I would like to reference the cell in column F that is in the same row of the corresponding date that is within this week in column B.
I have tried VLOOKUP but cannot produce a formula based on date within the current week.

 

[Roderick_E]

The question isn't clear but it sounds like you will need a column using =weeknum(B2) Which will give the week number and then look into using
index and match to return the value from column F.

 

[jmurphyamodeo]

The question isn't clear but it sounds like you will need a column using =weeknum(B2) Which will give the week number and then look into using
index and match to return the value from column F.

Sorry, it's tricky to explain. - below is the data.
[TABLE="width: 508"]
<colgroup><col span="2"><col><col span="3"></colgroup><tbody>[TR]
[TD][/TD]
[TD][TABLE="width: 508"]
<colgroup><col span="2"><col><col span="3"></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Contract[/TD]
[TD]Forest Grove[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="colspan: 2"]Dates[/TD]
[TD]Required Hours[/TD]
[TD="align: right"]4.00[/TD]
[TD]Hours Owing[/TD]
[TD]Running Total[/TD]
[/TR]
[TR]
[TD]2016-02-29[/TD]
[TD="align: right"]2016-03-04[/TD]
[TD] [/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]3.00[/TD]
[TD="align: right"]3.00[/TD]
[/TR]
[TR]
[TD="align: right"]2016-03-07[/TD]
[TD="align: right"]2016-03-11[/TD]
[TD] [/TD]
[TD="align: right"]4.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]3.00[/TD]
[/TR]
[TR]
[TD="align: right"]2016-03-14[/TD]
[TD="align: right"]2016-03-18[/TD]
[TD] [/TD]
[TD="align: right"]4.00[/TD]
[TD="align: right"]0.00[/TD]
[TD="align: right"]3.00[/TD]
[/TR]
[TR]
[TD="align: right"]2016-03-21[/TD]
[TD="align: right"]2016-03-23[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]4.00[/TD]
[TD="align: right"]7.00[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am trying to have the cell next to Forest Grove to return the result of 7.00. But next week I want it to show the cell that would be below the 7. I only want to see the current running total next to the header. Does that help? I feel like I've been starting at this too long.

 

[Peter_SSs]

Welcome to the MrExcel board!

Can you clarify what "within this week" means for you?
Some people consider that a week starts on a Monday & ends on Sunday, others use Sunday - Saturday etc