Activate hyperlink base on date

Good day all!!!

I have a file with data on certain cells that I wanted to hyperlink to another sheets. I wanted the hyperlink to be activated ONLY after a certain date - system date (say, if system date is greater than Jan 5, 2005, make a hyperlink on cell b1 in sheet1 to cell a2 in sheet2; if system date is greater than Jan12, make a hyperlink on cell b3 in sheet1 to cell a2 in sheet3, and so on). The link will remain active, of course, unless the system date is changed.

Can someone help me on this pls...

A million thanks...

Re: Activate hyperlink base on date

bump

Re: Activate hyperlink base on date

Hi Andy,

Thanks for the reply...
And sorry for the delayed response....

I tried ur formula... and it worked...
But I wanted also to display the text, but not activate the hyperlink...

I put it this way:

=IF(D1>TODAY(),HYPERLINK("#Lesson1!A2","Lesson1"),"Lesson 1")

Here's my problem now:

If the date in D1, is less than TODAY(), there is still a hyperlink in the text Lesson 1, and once u click it... a message will display, "Cannot open the specified file."

Is there something missing in my formula?

Thanks again....