Inserting date into a URL in a cell

I'm building a macro in another software and I've a list of 20 URLs in Excel.

At the end of each URL there is a date in the format YYYYMMDD

I have the URLs in Cell A 1-20

I've the date I need in cell B4 it reads 20180810

my urls are http://www.MYURL.com/date=*****

I was trying to add my date to this area ***** I tried adding =B4 to the end of the URLs but didn't work

I know I could do a find and replace to add the date but wanted to know if there was a way to add it dynamically

Let me know
thanks
David.

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Pete