title: How to show value in a cell only if current month
body: <p>My first time here, my question is this:</p>
  
  <p>I have 6 cells lets say A2,B2,C2,D2,E2,F2  each cell value is driven by formula. </p>
  
  <p>Above each of those cells I have named months like A1=October, B1=November, C1=December, D1=January, E1=February, F2=March. </p>
  
  <p>What i want to do is show the value of A2 since we are in October but don't show the value of B2, C2, D2, E2, and F2, then once we are in November still show the value of A2 and B2 but not the rest, once December show A2, B2, C2 and so on. </p>
  
  <p>The formula I'm using now is this: </p>
  
  <pre><code>=IF(MONTH(TODAY())&gt;=10,(C27+D24)-(Q15+E35),"0") 
  </code></pre>
  
  <p>It works all good but when it comes to December and January I cant get it to work. If I use <code>=IF(MONTH(TODAY())&gt;=12</code> it wont show the value of December which is good but once January rolls in then the value of December will show 0. </p>
  
  <p>Any help would be greatly appreciated, one more thing I can not use a macro. Thanks again </p>