title: Return the 30th day previous month in excel
body: <p>I want to return the 30th of each day for the previous month in excel. I used:</p>
  
  <pre><code>EOMONTH(A1,-1)
  </code></pre>
  
  <p>But that will always return the last day of the prevois month. How could you do it so for example the 30th June will return the 30th May NOT 31st May which is returned by the 'EOMONTH' function.</p>
  
  <p>Thanks</p>