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.