Hyperlink to cell depending on content

[scotthannaford1973]

Hi all - any assistance here would be greatly appreciated; I have a spread sheet that is used as an annual leave register and in cells N3:NR3 I have a series of dates (i.e. N3 = 1st Jan, O3 = 2nd Jan, P3 = 3rd Jan etc).

I'd like to create a dynamic hyperlink in a cell that will jump to the cell that contains today's date.

Any help much appreciated!

 

[FormR]

Hi, welcome to the board!

You could try:

=HYPERLINK("#"&ADDRESS(ROW(N3),COLUMN(N3)+MATCH(TODAY(),N3:NR3,0)-1),"Link to today..")

 

[scotthannaford1973]

Hi, welcome to the board!

You could try:

=HYPERLINK("#"&ADDRESS(ROW(N3),COLUMN(N3)+MATCH(TODAY(),N3:NR3,0)-1),"Link to today..")

worked like a dream - cheers!