Add (today) date within body of Excel chart

[1945Steve]

(I'm a novice user of Excel-Office Pro 2019)  I have a number of charts within Excel files that show data of performances over weeks and months.  I know this is a simple question, but its driving me crazy.  I want the chart to show "today's" date in or near the "Chart Title".  I have a cell in the worksheet - B1 with =TODAY().  Works fine - 1/22/2021 etc...  What/how do I get the 1/22/2021 to show in the chart? (For viewing, not as a header/footer for printer page.)  I've tried using insert text box, date is not dynamic. 

Thanks, Steve

[#2]

@1945Steve 

Click on the chart title.

Type = and point to the cell containing the =TODAY() formula, then press Enter.

[#3]

@Hans Vogelaar 

I did as you said, it deleted the original title and replaced it with the date.  How do I keep the original title "January Sales figures" and add the date (cell B1) 1/22/2021.  So it reads "January Sales figures 1/22/2021"

Steve

[#4 · Accepted solution]

@1945Steve 

Change the formula in cell B1 to

="January Sales figures "&TEXT(TODAY(),"m/d/yyyy")

[#5]

@Hans Vogelaar 

Perfect...  Exactly what I needed.  Many thanks,

Steve