Change the month only in a list of dates on my sread sheet

Topic

New Reply

I have a list of dates on my spreadsheet that run from Mar 01 to 31 etc. I just want to change the month in a copied new column to Apr keeping the same days.

Is there a formula? I’ve tried various options & none seem to work. Suggestions appreciated.

Regards

Ed

Reply | Quote

Replies

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)

Steve

Reply | Quote

worked like a charm. Thank you.

Reply | Quote

Only works when there are 31 days in the month, obviously.

cheers, Paul

Reply | Quote

Only works when there are 31 days in the month, obviously.

WHich was why I indicated: “(change the number if you want to go from a month with less days)”…

Steve

Reply | Quote