Hyperlink formula

[TlgKill]

is there a way to use a "if,today,hyperlink" formula to jump to a cell within the work sheet that jumps to todays date?

[Spitzerpl]

Yes. I created a hyperlink for a calendar page that is as follows...

Please Login or Register  to view this content.

This formula generates the cell as a hyperlink EVEN if the formula is an error (If the list it points to does not contain the date of the cell). I suppose I could fix it by finding a solution that does not use the IFERROR function. However I got around this by having the calendar highlight any of the dates where the hyperlink would actually work.