In this tutorial, you will learn how to get the same date next year. 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 year

## Formula

`=EDATE(date,12)`

## 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 year, we will put 12 months.

## Example 1

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

`=EDATE(B3,12)`

*Figure 1. Get the same date next year*

As you can see from the picture, we want to get the same date next year 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 12 months which is 30-Jun-18.

One specific example of this formula is when a date is in February in a leap year. In the cell B4, you can see that we have 29-Feb-16, which is the last day of February in the leap year 2016. The result in C4 is 28-Feb-17, which is the last day of February in the 2017 year.

## Leave a Comment