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

Mike

"beatrice" wrote:

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?