Hyperlink to Today's Date

Hi

I have dates stored in an Excel Worksheet as follows:

C13:C272 (2020)
J13:J272 (2021)
P13:P272 (2022)
V13:V272 (2023)
AB13:AB272 (2024)


Other columns are populated with related data.

I would like to be able to hyperlink to a cell in any of these columns that match today's date. Hyperlink to be in cell B9 on the same worksheet.

Are you able to help with the formula to achieve this please?


Many thanks



Maid1812

Hi - so we are all on the same page, can you explain what you mean by hyperlink? So if a date in B9 matches C45 (for example) what do you want B9 to do?

Thanks