• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hyperlink to TODAY() not working as expected

E

Emeng

Member
Hi all

I have a hyperlink which finds today's date in a column of dates that has worked normally till now.
Code: 
=HYPERLINK("#a"&MATCH(TODAY(),A2:A1048576,0),"GO TO TODAY")
Today however, it is finding yesterday!

I'm working from a work computer which is part of a worldwide network, so I expect the internal/system clock is accurate. The time/date on my machine is accurate as well.

I thought it may be a system clock is set to GMT but it's 'today' there now.

Does anyone have an idea why this may be happening?

Very curious??

Regards Mark
 
Hi Mark ,

The formula has been written that way ; you are using the MATCH function to find out which cell in column A has today's date ; suppose the cell A137 has the date ; the MATCH function will return 136 , since you are looking up the date in the range A2:A1048576. So , if there is a match in cell A2 , the MATCH function will return 1 , and the hyperlink will take you to cell A1 , which presumably will have yesterday's date.

Change your formula to :

=HYPERLINK("#a"&MATCH(TODAY(),A1:A1048576,0),"GO TO TODAY")

and it should work.

Narayan
 
Thanks Narayan,

I have a better understanding of how that formula actually works now.
I must have accidently clicked in the cell A2 while reviewing the formula at some time...

Regards Mark
 
You must log in or register to reply here.
Back
Top