Hi
I have dates stored in an Excel Worksheet as follows:
C13:C272
J13:J272
P13:P272
V13:V272
AB13:AB272
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.
Are you able to help with the formula to achieve this please?
Many thanks
Maid1812