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.