Get same date next month

★ 20 minutes read

In this tutorial, you will learn how to get the same date next month. To be able to calculate this day, you will have to get familiar with EDATE function. This function returns a date in a certain number of months.

Get the same date next month

Formula

=EDATE(date,1)

Explanation

Let’s first look at EDATE function definition. This function returns a date in a selected number of months. Parameters of the function are Date – a date for which we want to add a certain number of months. Months – a number of months that we want to add on a selected date. Because in our case we want to get the same date next month, we will put 1 month.

Example 1

In our example, we have dates in column B (“Date”), while in column C we want to get the same date next month. Let’s look at the formula:

=EDATE(B3,1)

 

 

Figure 1. Get the same date next month

As you can see from the picture, we want to find the same date next month in the cell C3 for a date in cell B3 (30-Jun-17). The result in cell C3 will be the date in B3 plus 1 month which is 30-Jul-17.

 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar