Hyperlink to today's date in a row.

[DaveEade]

Morning folks - hope you can help.

I'm trying to create a hyperlink that goes to "today's date" when the date rates sits in one row over multiple columns.

I've seen some videos on you Tube but the all seem to list dates in rows, I've tweaked the formula but it comes back with "Reference isn't valid"

My dates are in the range JF4 - QT4

here is my formula: =HYPERLINK("#4"&MATCH(TODAY(),JF4:QT4,0),"TodaysDate")

Can someone point out where I'm going wrong?

Many Thanks

Dave

 

[djclements]

HYPERLINK is expecting a range reference. You can build a range reference using the ADDRESS function. For example:

=HYPERLINK("#"&ADDRESS(4,COLUMN(XLOOKUP(TODAY(),JF4:QT4,JF4:QT4))),"TodaysDate")