Hyperlink to TODAY()

[Emeng]

HI

I would like to create a hyperlink to take me to today’s date in a list of dates in the same worksheet. Any help much appreciated.

Regards Mark

 

[NARAYANK991]

Hi Mark ,


Define a named range called , say , TODAY , referring to :


=INDEX(List_of_dates,MATCH(TODAY(),List_of_dates,0))


where List_of_dates is the range containing a list of dates.


Now , in a cell , enter the formula :


=HYPERLINK("#today","TODAY's DATE")


Clicking on this hyperlink , will take you to the cell within the list , which contains today's date.


Narayan

 

[Emeng]

thanks Narayan, works a treat!

 

[Vlad.olt]

Thank you very much, this has worked great for me as well!