VB Code to compare 2 columns of data

[rizmomin]

Hello:

Please refer to attached file.
I have date in Column A and check # in Column B.
I need VB Code to go thru the data and do the following:
Compare the check# with the date.
I need a unique check number for a given date.
Looking at the attached file, i have highlighted yellow.
Here i have Check # 2947 for 6/1/2016.
Now i see Check # 2947 for 6/15/2016.
SO in this case i need to add 1 at the end of check # for 6/15/2016.
So the yellow highlighted field would become "29471"
I have other data down the list the same issue.
I hope this is clear what i am trying to accomplish

Let me know if you have any questions.
Thanks.

Riz