Hyperlink point to specific cell in another sheet

[Schturman]

Hi to all
I need some help with hyperlink that should point to specific cell in another sheet
In Sheet1 I have a row with dates like you can see in the picture:

It start from first week of year in A2 (31/12-06/01/2024) and finish in FI2

In Sheet2 I use this formula to jump to a specific cell:

=HYPERLINK("#'"&C1&"'!"&ADDRESS(2,DAYS(TODAY(),RIGHT(Sheet1!A2,10))/2.27),"Open link")

It working but not exactly to week that I need... For example if date "16/01/2024" it jump to week "07/01-13/01/2024" instead to week "14/01-20/01/2024"
or if "14/01/2024" it jump to week "31/12-06/01/2024" instead to week "14/01-20/01/2024"
Can someone help me to fix my link or maybe to do this completely in different way ? That mean by TODAY() find the correct week in the Sheet1 and jump to it..
Thanks

 

[Tetra201]

See if the following formula works for you:

=HYPERLINK("#'"&C1&"'!"&ADDRESS(2,(WORKDAY.INTL(TODAY()-1,1,"1111101")-RIGHT(Sheet1!A2,10))/7*3+1),"Open link")

 

[Schturman]

See if the following formula works for you:

=HYPERLINK("#'"&C1&"'!"&ADDRESS(2,(WORKDAY.INTL(TODAY()-1,1,"1111101")-RIGHT(Sheet1!A2,10))/7*3+1),"Open link")

WOW! Thanks ! Working perfectly !
Please can you explain me this part "1111101" ? What it means ?
From the formula WORKDAY.INTL it should be weekend...
Thank you !