Help with Hyperlink to today's date

**hohamer9876** · 03-20-2024, 10:17 PM

Hi everyone.

I have a small problem with a hyperlink in my form. which calculates wages based on hours worked, before and after taxes.
I have a hyperlink at the top of the page that could take you directly to today's date in the form, but it doesn't work. And i can't for the life of me understand why. I've scoured the internet and tried tons of ways to get this to work, but I always end up with a broken link or errors.

What I'm trying to accomplish is that the hyperlink takes you to today's date and highlights the date cell in a different color.

Does anyone here have any good ideas on how I should proceed?.

**Sam Capricci** · 03-20-2024, 10:42 PM

I did it using a helper cell where I put the address that shows for today. then pointed the hyperlink at it. see attached for I2 that has the address for the cell for today and the hyper link that was changed in H2.

**hohamer9876** · 03-20-2024, 11:04 PM

Hi sam. Thanks for your quick answer.
I'm sorry, but it doesn't work on my computer. I have put the form on my google drive, and granted you editing rights. Maybe you can make it work there?.

docs.google.com/spreadsheets/d/1csHVIhcWQBaXwI6e_9fIKHmH7BpOi0kQ/edit#gid=1326507239

.

**DJunqueira** · 03-20-2024, 11:13 PM

It worked fine with me, could it be a regional version problem?

**hohamer9876** · 03-20-2024, 11:24 PM

No, I do not think so. I tested the hyperlink both on my computer and on online excel editors with the same result.
But in the link I gave you above, you can edit the form online directly, and if it works there, it works globally regardless of versions.

**Sam Capricci** · 03-21-2024, 07:10 AM

Ok, the issue - at least in the google sheets version, is that you have to replace the commas with semicolons, so my version uses commas so this formula in I2 =ADDRESS(MATCH(TODAY(),C:C,0),3,4,1)
will need to be (in that version of google sheets) =ADDRESS(MATCH(TODAY();C:C;0);3;4;1)
also hypperlink will have to change to =HYPERLINK("#"&I2;"Gå till dagens datum")
give those changes a try to see if that works.

**DJunqueira** · 03-21-2024, 07:45 AM

That sort of thing would justify why it worked with me so fine.

**Sam Capricci** · 03-21-2024, 07:48 AM

That sort of thing would justify why it worked with me so fine.

Thanks for the support!

guess we'll have to wait to see what hohamer9876 says.

**hohamer9876** · 03-21-2024, 08:04 AM

No, sorry, it doesn't work. Can you change it directly in the sheet please.
Is there something easier to achieve this?. Like the 'today's date' is marked directly when you open that page documen?.

**Sam Capricci** · 03-21-2024, 08:27 AM

well I hadn't noticed the merged cell before in G2:H2 so the formula for the hyperlink should be in G2 instead of H2. But apart from that the only portion I'm able to get to work is the address in the sheet but not the hyperlink.

**hohamer9876** · 03-21-2024, 08:36 AM

I tried this: =HYPERLINK("#C"&MATCH(TODAY(),C8:C38;0)+7," Today's date")
But that didn't work either.

Is it possible to mark the 'today's date' directly when the document loads?.

**Sam Capricci** · 03-21-2024, 08:49 AM

did you try this adjustment to your hyperlink formula... =HYPERLINK("#C"&MATCH(TODAY();C8:C38;0)+7;" Today's date")

as far as

Is it possible to mark the 'today's date' directly when the document loads?.

this formula will always show today's date when opening the document... =TODAY()

**hohamer9876** · 03-21-2024, 08:57 AM

=HYPERLINK("#C"&MATCH(TODAY();C8:C38;0)+7;" Today's date") didn't work either, or am i doing it wrong?.
Please test your theories here. Edit away as much as you want

docs.google.com/spreadsheets/d/1csHVIhcWQBaXwI6e_9fIKHmH7BpOi0kQ/edit#gid=1326507239

.

**Sam Capricci** · 03-21-2024, 09:22 AM

I am having no luck with changes to your google sheet, but I have no experience (except for today) working in google sheets. I can only get the address to work, the hyperlink doesn't error out, it just doesn't activate.

**hohamer9876** · 03-21-2024, 09:34 AM

It is exactly the same result that I get in Calc in Openoffice. Wondering why this is happening.
Is there any code that can be used, that will highlight that correct date in the date column #C directly when the document is loaded instead?.

**Sam Capricci** · 03-21-2024, 09:37 AM

I've bumped this issue to people with more experience than I have to see if they can offer a better or different WORKING solution. Good luck.

**AliGW** · 03-21-2024, 09:52 AM

Is this a GoogleSheets or an Excel question?

**TMS** · 03-21-2024, 09:55 AM

@Sam: I checked out your approach. The Helper cell works for me:

Formula:

Please Login or Register  to view this content.

Where I2 contains:

Formula:

Please Login or Register  to view this content.

The formula evaluated to C28

So then I tried replacing the Helper cell with the formula:

Formula:

Please Login or Register  to view this content.

This also worked for me so, in theory, you don't need a Helper cell.

**Sam Capricci** · 03-21-2024, 10:38 AM

@Ali, it appears to me it is a google sheets issue as every time i go to the link it opens google sheets. I really have never worked in google sheets so I am not sure my formula should work.

@TMS, I was sure it could be done in one formula w/o a helper cell, thanks for working it out.
will have to see what hohamer has to say.

**AliGW** · 03-21-2024, 10:49 AM

I've moved it to the GoogleSheets section.

**TMS** · 03-21-2024, 11:13 AM

Maybe this: https://docs.google.com/spreadsheets...),C:C,0),3,4,1)

But, when I tried to edit a Title, I messed it up

See: https://support.google.com/docs/answ...-a-spreadsheet

**hohamer9876** · 03-21-2024, 11:25 AM

No worries my friend

You messing things up means that you are testing and experimenting. Keep on trucking (:

I have backups... so I can just restore it. if we lose everything.

**hohamer9876** · 03-21-2024, 11:30 AM

Excel question.

However, I don't have an Excel editor on a server. so google are serving as a mediator for those who want to try to LIVE testing and editing their theories, on how we solve this mystery.

.

**TMS** · 03-21-2024, 12:01 PM

I shouldn’t mess anything up. I put the link I was testing in the cell above yours so, if it doesn't work, we can just delete it.

I followed the instructions to create and copy a link to a specific cell, C28 in this case. That worked and then I replaced C28 with the formula, and that worked. It's only when I tried to put a link name in that it went wrong.

Problem is, I don't really know how to drive Google Sheets.

**janmorris** · 03-22-2024, 06:03 AM

You need to include the gid of the sheet.

Here is the final working formula for the new sheet named "Kopia av Tidrapport"

Please Login or Register  to view this content.

Note that you must change the gid to suit the sheet that you are trying to reference.

You can get the gid from the URL in your browser.

**AliGW** · 03-22-2024, 06:07 AM

Originally Posted by hohamer9876

Excel question.

However, I don't have an Excel editor on a server. so google are serving as a mediator for those who want to try to LIVE testing and editing their theories, on how we solve this mystery.

.

Why Google? Members can open workbooks in the 365 browser if you instruct them to do so. I think using Google is inevitably going to lead to errors when ported to Excel.

I have moved the question back to the Excel section.

**janmorris** · 03-22-2024, 06:17 AM

I have provided solution for XLSX stored in Google Drive.

If the user has the file on their own computer then they would need to create a HYPERLINK formula based on MS Office standards.

Office support link: HYPERLINK function - Microsoft Support
https://support.microsoft.com/en-au/...7-7de9b76f577f

Screenshot 2024-03-22 at 17.14.58.png

I have tested these working in Office 16 for Mac:

Please Login or Register  to view this content.

Help with Hyperlink to today's date

LinkBack

Thread Tools

Rate This Thread

Display

Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Re: Help with Hyperlink to today's date

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Hyperlink to TODAY date in a range

Hyperlink to Today's Date

[SOLVED] Jump to Today's Date with hyperlink or Macro

Enter today date on other sheet from hyperlink

[SOLVED] Hyperlink to today's date

[SOLVED] Hyperlink to today's date

[SOLVED] Hyperlink to jump to today's date

Bookmarks

Bookmarks

Posting Permissions