CODEWITHSUNDEEP
excel
Tobias Glaus
Tobias Glaus

Reputation: 3628

Excel: Hyperlink to jump to current date

I got an Excel sheet with all the dates of the year. And on the Top i want to do a link to jump to the current date... I got this

=HYPERLINK(VERGLEICH(HEUTE();D:D;0))

Thats just giving me the number of the line, where the current date is located. By the way: Vergleich = Match // Heute = Today

How do I do that?

Upvotes: 0

Views: 4715

Answers (2)

Axel Richter
Axel Richter

Reputation: 61915

If HYPERLINK shall link to a cell, D12 for example, then the hyperlink address must be #D12. So =HYPERLINK("#D12") will work.

If the 12 shall be variable according to a matched value, todays date for example, then this value must be concatenated into the hyperlink address.

Example: Column D contains date values. One of those is todays date.

=HYPERLINK("#D"&MATCH(TODAY(),D:D,0))

German Excel:

=HYPERLINK("#D"&VERGLEICH(HEUTE();D:D;0))

This works only if in column D are date values, not strings, and really date values only, without time, and todays date is among them.

Upvotes: 2

Gary's Student
Gary's Student

Reputation: 96773

Say we have dates in column D like:

enter image description here

This formula will give the proper row for the cell containing today's date:

=MATCH(TODAY(),D:D,0)

We can use this in the hyperlink formula:

=HYPERLINK("#D" & MATCH(TODAY(),D:D,0),"today")

For example:

enter image description here

Upvotes: 1

Related Questions