Go Back

Get same date next month

Read time: 20 minutes

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




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:




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.


Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I want to calculate next date quarterly, semi-annually, annually for date entered. If day is greater than 28 then next date would be 1st of the 4th month for quarterly, 7th month SA, 13 months annually.
Solved by M. W. in 12 mins
Based on date of arrival 1/20/19 I need a formula that will choose only even months following the date of arrival. Based on this information: If next even month is greater than 1 month up to 3 months from arrival date than soonest even month is chosen If arrival date is less than 4 weeks from next even month than use the following even month (ie. MARCH 2019 is the month that needs to be chosen for the above date of arrival)
Solved by S. B. in 12 mins
I have a sheet with transaction for a month. Each month I get a new transaction sheet. I need a pivot table to calculate the total transactions for each day. However, before that, I need VBA/Macros to add in the date next to the qty sold, it is currently placed next to the receipt#.
Solved by C. Q. in 24 mins

Leave a Comment