title: Using Excel "IF" Function to Assign Months to Cells
body: <p>I have a spreadsheet containing multiple cells that are formatted as dates.  What I would like to do is write an "IF" statement that I can copy and paste that will check the first value in the cell and then come up with a month.  For example, I have a cell that has a value of <strong>9/30/2014</strong> and I am trying to do the following:</p>
  
  <pre><code>IF(LEFT(A2,1) = 9, "September", "NULL")
  </code></pre>
  
  <p>This is throwing me a value of "NULL" for some reason.  Any guidance on how to get this to work would be appreciated.</p>