title: Calculate week numbers for months through excel formula
body: <p>My week starts from Saturday to Friday and I need to count no of Weeks. E.g. Week starting from <code>27th Oct 2018</code> to <code>2nd Nov 2018</code> should be counted as first week of month November but formula is calculating it as Week 5 of October month. Below is the formula I have been using.</p>
  
  <pre><code>=IF(K89="No Date","No Week",CONCAT("Week ",WEEKNUM(I89-1)-WEEKNUM(I89-DAY(I89)-6)))
  </code></pre>
  
  <p>where <code>K89</code> is a date column.</p>
  
  <p>Any suggestions, please.</p>