title: if A1 = 1 then cell value =A1, if it is 2 then i wanted the formula to change to A2,
body: <p>I need some help here with my work.
  I am doing pure formulas in excel and won't be using anything else.</p>
  
  <p>sorry to confuse u guys, maybe I'll change my question a tad more clearer to what I need.</p>
  
  <p>I wanted to increment my cell references in the formula every time a day is added.</p>
  
  <p>let's say today was Feb 1, 2014. I'd set A1 = 1, now when I enter Feb 2, 2014 on my date entry cell. A1 should change to 2.</p>
  
  <p>I need the proper formula for this statement as follows, If A1 = 1, then B2 = H2, B3 = H3, now when A2 changes to 2 after the date change, my formula should become B2 = H3, B3 = H4, I can't get this part.</p>
  
  <p>Many thanks!!</p>