How to date tabs in sequential order using Macro

Hello,

Not too long ago I came across a helpful Marco that dated each Excel worksheet tab in sequential order with the Month and Date (i.e. Nov 1 for one worksheet, Nov 2 for the second etc.)

I wrote it down and perhaps in the wrong manner because I cannot get it to work. Of course, I failed to jot down the steps I followed along the way and cannot find the site where I initially found it.

Could someone help me? Here's what I wrote down:

DIM DATE 1 AS DATE
DATE1= ("NOV 1, 2014")
MSGBOX YEAR (DATE1)

DATE2= DATEADD ("M","D")
MSGBOX DATE 2

I've already attempted to locate the macro in the previous workbook where it was used but it would not come up. So any help would be appreciated. I am not familiar with Macros much so the less complicated the better.

Thank you!