title: vba convert week number (and year) to date?
body: <p>I have a <strong>week number</strong> in Cell C13 and a <strong>year</strong> in Cell C14.</p>
  
  <p>I am using the below formula to <strong>convert this into the Thursday of that week</strong> number's date:</p>
  
  <pre><code>=DATE(C14,1,-6)-WEEKDAY(DATE(C14,1,3))+C13*7
  </code></pre>
  
  <p>How could i do the same thing using VBA?</p>