I'm looking for help with a code problem. In my sheet I have a cell that has the year in 4 digits plus 5 other digits for incidents in our fire dept. (ie 2008#####) what I want is to have the year automatically change to 2009 on the first day of the new year. Is this possible? If so how?

As always any help would be greatly appreciated!