Not sure how to do it with a hyperlink, but you can do it with a simple macro that you could assign to a button.
Let's say your date column is A1:A1300.
You need to set another cell (let's say B1, to be the function =today().
Then the macro would be :
For Each c In Range("A1:A1300")
If c.Value = Range("b1").Value Then
Hope this helps ........ Ralph