title: Excel VBA > update date to +1 hour when between 2 dates
body: <p>I have 2 columns on dates, lets say A1:A100 &amp; B2:B200 that may fall in between 2 dates ( in this case its the British Summer time range )</p>
  
  <p>Can you help with a sub to update the range of cells with an extra hour if they fall between those 2 dates)</p>
  
  <p>thanks
  James</p>