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.

Example:

get same date next month

As you can see in the image above, we have taken a bunch of dates that we need to convert in the next month.

get same date next month

Step 1: Input the formula =EDATE(

The first thing to do is to input the EDATE Function which is as follows:

=EDATE(

Step 2: Input the required values in the formula

The following formula requires start date and months.

get same date next month

The start date will be the date available in the hand. In the above example, the same is cell B2.

get same date next month

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:

=EDATE(B2,1)

get same date next month

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.

get same date next month

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!

get same date next month

And there you go, the date given gets converted into the very next month.

get same date next month

It’s easy, isn’t it?