Creating a formula that checks a variable number of columns

Hi, have what I assume to be a relatively simple query.   I'm trying to create a formula for a spreadsheet that I have which I need to add columns periodically to (one for each week) to log attenda...