hyperlink to todays date in row

Hello Gurus,


It appears that you can setup a hyperlink to match todays date in a row. However, I cannot get it to work. I am not fully understanding the formula requirements.

Please see the attached document example.

TIA,
Tim

Thanks Bo_Ry... for the input. I had to modify is slightly to make it work for my exact worksheet, but this got me in the right direction.