title: append non-numeric characters onto a date, but retain the ability to drag formula across
body: <p>hoping someone can help me, perhaps my problem is best described with an example.</p>
  
  <p>In cell D5, I have the year 2010.</p>
  
  <p>I wish to append the following to that date - '/xA' where x= the last two digits of the current cell +1. In this case, making 2010/11A.</p>
  
  <p>I would then like the ability to drag this across the row, so the next cell would be 2011/12A and the next 2012/13A and so on.</p>
  
  <p>If 2010 was located in cell D1, in cell E1 I would use the formula D1+1 to get 2011. In cell C1, I would use D1-1 to get 2009. I would like to do something similar, but for the above example.</p>
  
  <p>I have tried playing with custom formatting and the use of the &amp;, (i.e. =2011 &amp; "/" &amp; right(D5+2,2)), but the placement of the "/" gives an error when dragging across.</p>
  
  <p>Thanks!</p>