Excel 2007 : need formula to work only if the cell is populated

Well I think I figured it out, the formula you wrote only goes back a few cells. I need the formula to check all the way back to B3 from C10 if necessary. If the counters were not checked all week long, Sometimes that happens. The day they are checked is never the same, it would need to get the starting counter from B3.