title: Dynamically updating date in Excel
body: <p>I need to create a dynamically updating date in Excel.</p>
  
  <p>Right now in Cell A1 I have the text "updated through"
  In B1 I have the formula =Today()-1.</p>
  
  <p>I join them with (&amp;) in C1. The problem is that it is displayed as "updated through 43514" I've tried formatting the cell as a date (ie 2/19/2019) but it won't work. How can I do this, or is it even possible?</p>