Hyperlink does not update when manually changing the date within the URL

I have a hyperlink to a web site that is 425-450 characters depending on the account. I have issues.

The dates inside the URL change based on month so I cannot hard code the URL in the cell, even though this gets around the function's 255 character limitation when I click on the link.

I hard coded the date to April in the URL and it worked, giving me the April data webpage. However, I then did a find/replace to change the date parameters to March dates then clicked on the link, I still got the April data webpage, even though the URL in the Excel cell had March dates.

If I choose to hard coded URL and find/replace the dates, how can I make the URL in the Excel cell update to the new date parameters? The webpage did update to March when I clicked on the cell then pressed F2 then click on the link, but I don't want to have to do that for 300 lines.

Or, can I use Power Query to help me still use the Hyperlink function, so that the cell only displays the Account number and still work on the ridiculously long URLs?