Hyperlink to today's date

Hi,

With your help I now know how to hyperlink to a specific cell in a specific sheet.

I would like to hyperlink to the cell with today's date in it (it is in column A). I know how to use Today(), but how do I assemble the hyperlink address to point to that specific cell?

Thanks as always

K

Originally Posted by Tony Valko

Assuming this is on Sheet1...

=HYPERLINK("#Sheet1!A"&MATCH(TODAY(),A:A,0),"Today")

I can't get this to work, but I'll work on it now I know the structure. Thanks

Originally Posted by Sambo kid

Must be more to this than I'm imagining but, open both sheets, in the sheet you want the link to the other cell, put your cursor in it and hit =, then go to the other sheet with the date in it and click on that cell, then hit enter and it will build the link. But you know, today should be equal in both sheets and I'm not certain but pretty sure that the hyperlinked sheet will not update with today's date unless you open it so it will likely only show the last date that coincides with the last date it was opened.

This just gives me the date number for today(). ? (42619)

Tony, thanks. The hyperlink is in the 1st sheet, called 'Index'. The dates are in 'Register.' I've modified your formula accordingly. I assume that the A:A in your function is the range name?

The formula ="A"&MATCH(TODAY(),Register!A1:Register!A10000,0) gives me the correct cell, A18 in this case. All I need to do now is include this in the Hyperlink.

Am I on the right road ?

Thanks

K

Yes! That works, mega thanks.

Does the A:A refer to the entire column? I assume so.

I was close i think, but you beat me to it I had too many " and too many &

Thanks again