Using INDIRECT() on Date type header

I am trying to dynamically calculate Week over Week for a spreadsheet, as new data is added to the columns every week on the date in the header. My data looks like so:

Name   WoW   9/27/2018   10/4/2018   10/11/2018   10/18/2018   10/25/2018
A      ?     100         120              
B      ?     120         140

WoW for A should be 120/100-1 = 20%. WoW for B should be 140/120-1 = 16.67%.

I was trying to use indirect() in cell B2 to calculate WoW like so: =INDIRECT(IF(MATCH(TODAY(),C$1:G$1,0),TODAY(),""))/INDIRECT(IF(MATCH(TODAY()-7,C1:G1,0),TODAY()-7,""))-1 however it just returns #REF!.

Any idea what I am doing wrong? Thanks!

P.S. On second thought it looks like this will fail on today()+1 through today()+6 so if there is a way to perhaps update the match() that would be highly appreciated