Is there any way this can be done without the =TODAY function? Because I'm worried that if I open this on a day that isn't actually today, it will change everything on the summary sheet. Also, only Bank Trade days are shown in my data, so when a formula counts back from today, and gets to a weekend (which isn't included in the data), won't that mess things up? For example, on Monday it should show Monday 1st, Friday 28th, and Thursday 27th. Won't a count back from the =TODAY function mess this up?