My columns are named by month and date "Jun-2017", "Jul-2017", "Aug-2017"
Cell GO1 formula: =TODAY()
I will use this report monthly so I want it to be dynamic every time I add a new months column of data.
In cell GM3 I have this formula. I want the formula to apply only within the last 36 months (last 36 columns) from the GO1 date.
=INDEX(Data!$B$2:$GJ$2,MATCH(TRUE,INDEX(Data!B3:GJ3<>0,0),0))
Any thoughts on how to do this would be very much appreciated.
Matt