Hi, very first post here, hoping someone can help.
I'm trying to devise a formula for a number of cells in column C that returns TRUE IF the column matching the current week number (stored in B2) on the same row as the formula is not blank.
Hopefully the image below helps with the description...