Hyperlink to jump to today's date

Hi there!

I am creating an Excel Calendar and I have the starting Date in B1 and the following date in B51 followed by B101,etc.

Is there any way I can create a Hyperlink in A1 which upon clicking will bring me to todays date?

Thank you very much in advance for your help.

not sure about a hyperlink - you can do this easily with a macro, though, which you could then attach to a button or similar in cell A1

This macro will take you to the first instance of today's date in column B, assuming the dates are in a numeric format:

Please Login or Register  to view this content.

Many thanks NickyC. That works perfectly. I just created my first macro and currently very pleased with myself if I may say so

Thanks so much.