Excel Formulas to Find the Next Anniversary Date ~ Simple Tricks!!

We are going to make use of a combination of the Excel EDATE and DATEDIF functions in order to determine the next anniversary date between a specified start and end date in days, months, or years. Let’s get them below!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

Use the below formula to get the next anniversary date in Excel.

=EDATE(date,(DATEDIF(date,as_of,”y”)+1)*12)

Syntax Explanations:

EDATE – In Excel, the EDATE function will help to add or subtracts the specified number of months with the given date and returns the serial number that represents the result date in Excel.
DATEDIF – The DATEDIF function helps to return the calculated difference between the two dates.
Multiplication (*) – In this symbol will multiply any two values or numbers.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Minus Operator (-) – This symbol will help to subtract any two values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Example:

Refer to the below example image.

Here we will enter the input dates in Column B and Column C.
Now we are going to calculate the next anniversary date from these two inputs.

Select any cell and type the above-given formula.

Finally, press ENTER to get the result out, if you need, drag the fill handle over range to apply the formula.

Verdict:

From this guide, you can get to know how to find out the next anniversary date between a specified start and end date in Excel. Please feel free to state your query or feedback for the above article.

Thank you so much for visiting *Geek Excel!! **If you want to learn more helpful formulas, check out Excel Formulas *!! **