title: Increment column based on date - Excel
body: <p>I am trying to create an excel formula that will increment as the year changes. The following is what i am trying to do: <br>
  <a href="http://i58.tinypic.com/nbc1fc.jpg" rel="nofollow noreferrer">http://i58.tinypic.com/nbc1fc.jpg</a></p>
  
  <p>I have 2 columns - date and id.
  What i would like to do is increment the ID column by +1 when the <strong><em>year</em></strong> changes in the date column. So, dates from the same year will get the same id. (i am not concerned by the month/day values, all i need to do is assign the same id to dates from the same year).</p>
  
  <p>I have tried a variety of formulas in excel but my excel skills are not great and i have been unable to find a solution. The best i could come up with is:
  IF(YEAR(A1=1928),420) but that would be quite monotonous to do for every year in the excel file.</p>
  
  <p>i did try to do a bit of research and the only similar question that i could find on here was this -->
  <a href="https://stackoverflow.com/questions/16187026/increment-number-when-date-changes">Increment number when Date changes</a></p>
  
  <p>Any help would be much appreciated</p>