Hyplink to Today's Date

[juul2222]

I have a file with multiple worksheets that I use =HYPERLINK("#"&CELL("address",INDEX(Date,MATCH(TODAY(),Date,0))),"TODAY") to jump to today's date. I don't remember how I added new worksheets to the mix and jumped to today's date other than adding a 1, 2, 3, etc. after "Date" in the two locations "Date" is found in the formula. I tried to just continue the "Date" series which currently ends at 5 with a 6, but that give me a #Name error. If I use the same "Date" number as the other sheets, it obviously just hyperlink's to today's date in those other worksheets. I'm not stuck with using that formula, just want to be able to hyper link to today's date. Thanks!

 

[jasonb75]

Looks like the cells you are jumping to are in a named range called 'date'
Check the name manager and see what is there.

 

[juul2222]

Name manager... duh. Figured it out, thanks.