title: Subtracting Days from Current Date
body: <p>I have an <code>expression</code> that shows the current day, month, and year:</p>
  
  <pre><code>=Mid(Today(),1,9)
  </code></pre>
  
  <p>How would I display the week before the current date? So if today is <code>6/26/2014</code>, it would show <code>6/19/2014</code> in the box next to it. I tried using <code>DateAdd</code> and adding <code>-7</code> but that gave me an error.</p>