Getting Data from website via URL changes

I'm trying to get excel to import data from the web based on a parameter set in a cell for the data. The person who will be using this is not going to be anywhere near competent with Excel, and I just want a button for them to press, for a macro I will write. I'm trying to get NOAA tide data from the following api.tidesandcurrents.noaa.gov/api/prod

I already figured out the query I need, I just need excel to look at it from a parameter I set as the current date.

api.tudesandcurrents.noaa.gov/api/prod/datagetter?product=predictions&application=NOS.COOPS.TAC.WL&end_date={today's date}&range=168&datum=MLLW&station=9450364&time_zone=lst_ldt&units=english&interval=1&format=xml

I'm trying to get {today's date} to be the date set in the cell of choice.

How do I set a url part to be an input i chose?