title: How to get name of the month in MS EXCEL
body: <p>Let's say in column A1, I have the below value in the format dd/mm/yy.</p>
  
  <p><strong>13/04/18</strong></p>
  
  <p>I need to print the name of the month which i <strong>APRIL</strong> in column A2.</p>
  
  <p>How can we achieve that?</p>
  
  <p>I've tried the below:</p>
  
  <ol>
  <li><p><code>=TEXT(date,"mmmm")</code> will work only if the format is mm/dd/yy. </p></li>
  <li><p>I've tried to change the date format to mm/dd/yy and then to the month name which works but I don't need one unwanted column</p>
  
  <p>IN B1 column   <code>=DATE(RIGHT(A1,2)+2000,MID(A1,4,2),LEFT(A1,2))</code></p>
  
  <p>IN C1 column   <code>=TEXT(date,"mmmm")</code></p></li>
  </ol>
  
  <p>Any help would be appreciated. Thanks</p>