title: Want to get previous date from current date
body: <p>i have problem finding solution on getting previous date from current's date. but i only want the months to change. for example, now is August, i want the output to display 3 months ago = May. 
  Heres my code that i wrote</p>
  
  <pre><code>givenDate= "14-August-15"
  
  DD = Day (givenDate)
  'MsgBox DD
  
  MM = Month (givenDate)
  'MsgBox MM
  
  YY = Year (givenDate)
  'MsgBox YY 
  
  SysDate = DD&amp;"/"&amp;MM&amp;"/"&amp;YY
  
  MsgBox Month(DateAdd("m", -3, "14-August-2015"))
  'MsgBox(FormatDateTime(SysDate,1))
  </code></pre>