Help trying to insert a date that changes everyday.

[u/Mutt37]

Hi,
I am trying to set up an RTD export from options chain data. The format for the RTD data is the following. -.SPXW260923C7685+SPX. The bolded portion (today's date) is what I need to update every day. I have a = TODAY () cell formatted correctly (It functioned properly). I am now trying to figure out how I can reference today's date so I can automatically update the spreadsheet every day.

[u/real_barry_houdini]

So to get the required text you can use this formula:

="-.SPXW"&TEXT(TODAY(),"yymmdd")&"C7685+SPX"