title: Date for Previous Monday Excel
body: <p>Today is 02/27/2013 which is Wensday.
  I need formula which will return me date for previous Monday.which would be (02/17/2013)</p>
  
  <p>I need to so I can use for file name or email subject in my vba code which sends emails.</p>
  
  <pre><code>With oMail
       'Uncomment the line below to hard code a recipient
       .To = "myemail@email.com"
       'Uncomment the line below to hard code a subject
       .Subject = "Current Report"
       .Attachments.Add WB.FullName
      .Display
  End With
  </code></pre>