Change and repeat month

[Sugar8042]

I would like to change a column wherein only the month needs to be changed for the whole column (day needs to stay the same). Rather than manually changing the month for each cell in the column, is there a formula to just change the month leaving day the same for the entire column? Can this be done? If so, how. Thanks. Susan

 

[Joe4]

Welcome to the Board!

If you entries are true dates, you can just add the number of days in that month.
Let's say that your values go down column A, and cell A1 has the date of January 1, 2018.
Since January has 31 days, place the number 31 in any blank cell.
Then, select that cell, select Copy, then select the entries in column A and then right-click, select Paste Special, select Values, and and click OK.
This will add 31 to all your dates in column A.

 

[Scott Huish]

The way I read that is with starting date in A1.
In A2:
=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
Copy down.

Excel 2010
	A
1	4/25/2018
2	5/25/2018
3	6/25/2018
4	7/25/2018
5	8/25/2018
6	9/25/2018
Sheet1

Cell Formulas
Range	Formula
A2	=DATE(YEAR(A1),MONTH(A1)+1,DAY(A1))
A3	=DATE(YEAR(A2),MONTH(A2)+1,DAY(A2))
A4	=DATE(YEAR(A3),MONTH(A3)+1,DAY(A3))
A5	=DATE(YEAR(A4),MONTH(A4)+1,DAY(A4))
A6	=DATE(YEAR(A5),MONTH(A5)+1,DAY(A5))

 

[Joe4]

The way I read that is with starting date in A1.

I might have misunderstood. I thought it was the dates of a (single) particular month.

 

[Fluff]

I was thinking that the Op had something like col A which needs to be changed to what's in col B, but leaving it in col A

Excel 2013 32 bit
	A	B
1	25/04/2018	25/05/2018
2	26/04/2018	26/05/2018
3	27/04/2018	27/05/2018
4	28/04/2018	28/05/2018
5	29/04/2018	29/05/2018
6	30/04/2018	30/05/2018
7	01/05/2018	01/06/2018
8	02/05/2018	02/06/2018
9	03/05/2018	03/06/2018
10	04/05/2018	04/06/2018
11	05/05/2018	05/06/2018
End