Hyperlink todays date

Hi, an easy one for you today I guess?

I want a formula to jump to todays date and found (props to Chester Tugwell)

Please Login or Register  to view this content.

Ive made this work across columns:

Please Login or Register  to view this content.

BUT each month is on a separate sheet, how do i change the array to include 12 sheets?
TIA

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Book11.xlsx
one row of dates.....
multiple sheets....

This proposal adds a cell (A2) which will contain the three-letter month code chosen via a data validation drop down.
The formula for cell B2 is: =HYPERLINK("#"&"'"&A2&"'!"&ADDRESS(1,2+MATCH(TODAY(),C1:AG1,0)),"Today")
Information about the formula can be found in the linked tutorial: https://www.contextures.com/excelhyp...n.html#formula
Scroll down to the section titled: 3) HYPERLINK Example - Excel File
From there scroll down to: a) Link in Same File, and then: 2) Use Cell References

Please Login or Register  to view this content.

probably a bit clunky but it works!

Not to say that this is elegant, however, you might want to try:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.
Also Thank You for marking the thread as 'Solved' I hope that you have a blessed day.