help with calculations for year/resetting counter
I'm trying to setup a log of all my various rolls of film. The catch is I want the unquie number to start with the last two digits of the year and then increment by 1 until the year changes. So 2006 has 3 rolls (0601, 0602, 0603). Now 2007 has 2 rolls (0701, 0702).
I was able to extract the last two digits of the year using the Right function, but I cannot figure how to make a counter that resets each year.