Forum Discussion
Last week with data reported monthly
So I have a sheet that is updated weekly. In version 1 tab, cell a1, this is where I manually input the date. From there, cells A6-A53, it dates back two years (Sep -17 cell A6) and goes forward two ...
That could be like
=(EOMONTH(TODAY(),0)+1>=A6)*LOOKUP(2,1/(Sheet5!C:C>0)/(A6>=Sheet5!A:A),Sheet5!C:C)