title: Formula to convert a week number to month
body: <p>I am trying to implement VBA code for converting the week number to month Name. </p>
  
  <p>I have a sheet in which column "A" contains week number from 1 to 52 . The week number 1 starts from column A3. I want the corresponding month Name for the week number to be printed.</p>
  
  <p>I tried a formula like this</p>
  
  <pre><code>=MONTH(DATE(YEAR(NOW()),1,1)+(B1*7))
  </code></pre>
  
  <p>The reason I tried an formula fisrt is to get the idea and then converting the formula to VBA. </p>
  
  <p>I am just getting the formula printed in my cell. Can anyone help me with this?</p>