I am currently creating a spreadsheet containing daily targets which will give me a running total. I've manged to get the formulae to work using a single date field which is ok, however, I really need to automatically pick a historic date.
For example when going into the sheet on Monday, the...