You can copy it then put 31 into a blank cell. Then you can copy the blank cell, then select the dates and paste special -values - add, to add the 31 days to make the days the next month (change the number if you want to go from a month with less days)