Hi John,
Thanks for this. I'm very restricted in terms of what I can add to the sheet and adding date fields (whilst obviously practical) isn't possible because the table (on my actual sheet) already has column headers and the sheet layout conforms to strict brand guidelines and we can't add to these.
After a bit of playing around, I adapted your formula to this, which I think will do the same thing without the addition of dates:
=INDEX($C18:$Z18,0,(((YEAR(NOW())-2015)*12+MONTH(NOW())-(NOW()<WORKDAY(EOMONTH(NOW(),-1),8))-2)-2)*2)
Unless you can see any errors with this approach?
Many thanks
Bookmarks