title: Excel determine previous Month and Year from an existing date
body: <p>I have a date field <code>7/12/2016</code> and I need to extract the previous Month Year from this date.  What is the best formula?</p>
  
  <p>Needed format of final data <code>Jun-2016</code></p>