Go Back

Get same date next year

Read time: 20 minutes

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.

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 need help to get a date in say column B, if a date in column A is within a fiscal year
Solved by E. H. in 28 mins
I need help with the following: Sales: Year-to-date. For each Rep Group, summarize year-to-date sales (ending in the month selected) compared to year-to-date sales (ending the same month in the year prior to the selected year). For example, if June and 2018 are selected in the two drop-down lists, then this report would compare year-to-date sales from Jan 2018Jun 2018, with year-to-date sales from Jan 2017Jun 2017. Hint: For example, how will using the number of the month instead of the name of the month help you create a formula to easily summarize all sales ending in June (month 6)? Average Unit Price: Year-to-date. For each Rep Group, summarize average year-to-date unit price (ending in the month selected) compared to average year-to-date unit price (ending the same month in the year prior to the selected year). For example, if June and 2018 are selected in the two drop-down lists, then this report would compare year-to-date sales from Jan 2018Jun 2018 with year-to-date sales from Jan 2017Jun 2017.
Solved by Z. S. in 26 mins
When I use vlookup, I get the date format but not the same date
Solved by K. H. in 18 mins

Leave a Comment

avatar