|If you continue to use that attitude in this forum, I will remove every one of your posts and have your membership cancelled.|
As moderator of this forum, I have edited your post to remove the insult.
The suggestion I offered works perfectly fine because Excel knows enough to increment the month but hold the day constant. Continue to drag the dates down for more than 12 months and the month will return to 1 but the year will increment. The day will remain constant at 1.
This list was created using the process I offered above and was copied directly from an Excel spreadsheet:
From where I am sitting, I can't see what you are doing wrong, but if you follow the instructions I offered, you will have a list of dates that all start at the first of the month. Just for fun, try starting with 10/29/2012 and drag it past February 2013. Watch how smart Excel is when it comes to Leap Years.
Feel free to apologize whenever you are ready.
Office Forum Moderator
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.