title: Calculating positive and negative numbers for past and future data
body: <p>I am trying create a data set and finding it difficult to do it manually. I just wanted to know if there is way we can do it automatically in Excel.</p>
  
  <p><a href="https://i.stack.imgur.com/MnCKd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MnCKd.png" alt="enter image description here"></a> </p>
  
  <p>As shown in the above image I need to do it 52 weeks. For e.g. 201703 ; 201704;201705...... 201752.</p>
  
  <p>Any help in this regard will be greatly appreciated!!</p>
  
  <p>Thanks,
  Ganesh</p>