Lauren3077
New Member
- Joined
- Apr 9, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
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.