Increasing the date incrementally

[bakerjase]

I'm sure this is a very simple thing to do, but I'm have a very hard time of it.

I have a macro that copies a worksheet and places it on the end. All the data is the same, but I need it to increase the day by one (I currently use the format mmm dd), is there a way to do this and have it change the month?

 

[Andrew Poulsom]

Just add 1 to the existing date.

 

[bakerjase]

I tried that and it wouldn't let me do it, but I think it may have been because I was using a custom cell format, I tried again with one of their settings and it works fine, thanks.