title: How to use vba get weekday name of a cell
body: <p>I ran this code but it shows type missmatch error.  The orginal data i have is 20181101</p>
  
  <pre><code>ws.Cells.Item(2, i).Value = WeekdayName(Weekday(ws.Cells.Item(1, i), 0), False, 0)
  </code></pre>