Hyperlink to a column that matches todays date

by Rubin|Published November 20, 2021

I have a staff rota (the dates are all in cells in seperate columns). I’m trying to create a HYPERLINK to jump to the column with today’s date. I have tried the following but this appears it is for rows as opposed to columns. I’m a excel novice so looking for advice.

=HYPERLINK("#2"&MATCH(TODAY(),E2:FC2,0)+1,"Jump to Today")