# change date

#### Lauren3077

##### New Member
I have a column of dates. They will all be different every month, but for last month range from 3/1/2021 to 3/31/2021. I need it to change the date to the last day of the month four months from the date. So, all of March's dates will need to change to 7/31/2021 but I need a formula that will change April's dates to August 31 and May's to September 30 and so on. It's a monthly spreadsheet. It also needs to start in D2 but go down as far as there is information, which is different every month. I saved this one until the end because I have no idea where to even start.

### Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

#### jasonb75

##### Well-known Member
but I need a formula that will change April's dates to August 31 and May's to September 30 and so on.
That's what EOMONTH is for
Excel Formula:
``=EOMONTH(D2,4)``
The digit at the end is the number of months to add, use 0 if you need the end of the current month.

#### Lauren3077

##### New Member
Oh man, that was so easy. Thank you guys so much for your help.

#### jasonb75

##### Well-known Member
that was so easy
Excel is always the same. If you think it will be difficult, it will be easy. If you think it will be easy, it will be impossible.

Replies
5
Views
430
Replies
5
Views
170
Replies
1
Views
92
Replies
6
Views
171
Replies
7
Views
152

1,136,283
Messages
5,674,831
Members
419,529
Latest member
TommasoP11

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back