When you are dealing with loads of data, and by mistakenly you make an error by writing all the dates of one month before it has to begin, this is what you can do to fix it.
As you can see in the image above, we have taken a bunch of dates that we need to convert in the next month.
Step 1: Input the formula =EDATE(
The first thing to do is to input the EDATE Function which is as follows:
Step 2: Input the required values in the formula
The following formula requires start date and months.
The start date will be the date available in the hand. In the above example, the same is cell B2.
Then we will come to the point of months. In the same, we will basically jot down 1 only, as we only need the date to be shown in one month ahead.
Step 3: Cross- check the formula and proceed
After inputting the same, we will close the formula. The overall formula becomes as follows:
Now all we have to do is press enter. After getting your answer, you need to simply drag down the formula for the rest of the dates to make your work easy.
Now, you must be wondering, that the following data shown above is not a date, this is because the same is in the general format.
So, to get the dates, we will go to the Number section and change the format from General to Short Date or Long, whichever is preferred by you!
And there you go, the date given gets converted into the very next month.
It’s easy, isn’t it?