Last closing stock number

[beatrice]

I have spreadsheet with 5 columns for weekly closing stock and a month to
date total. I want the total column to pick up the last weeks closing stock.
What formula do I use?

 

[Mike H]

Not enough information. I think the dates are in Column 5 of this table, am I
correct?

Mike