I will need some help on what should be the formula to use. I want column D to auto-increment when the date in column C filled. 19 represent 2019 and 20 represent 2020. The running number will start from 0001 when the year changed. Thanks.