Excel Formulas to Create a Series of Dates by Year ~ Complete Guide!!

So far, we have already seen how to generate a series of dates by day and month. Likewise, here we are going to see how to generate a dynamic series of dates with a formula that increases by one year from a single start date in Excel. 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

Generic Formula:

Use the below formula to create the dynamic series of dates by year in Excel.

=DATE(YEAR(date)+1,MONTH(date),DAY(date))

Syntax Explanations:

*DATE * – This function will combine three different values and returns them as a date. Read more on the DATE function.
YEAR – It helps to extract the year from the given date and returns the year as a 4-digit number. Read more on the YEAR Function.
MONTH – In Excel, the MONTH function will help to return the month of a date.
DAY – This function helps to return the day of the date. Read more on the DAY Function.
*Date * – It represents the input starting date on your worksheet.
Plus operator (+) – This symbol is used to add the values.
Comma symbol (,) – It is a separator that helps to separate a list of values.
Parenthesis () – The main purpose of this symbol is to group the elements.

Practical Example:

Let’s consider the below example image.

Here, we will enter the starting date in Column C.
Now we need to generate the series of dates by year starts from the given date.

So, apply the above-given formula and press the ENTER key.

Finally, you will get the result as shown below.

Wrap-Up:

So yeah guys this is how we can create a series of dates by year in Excel. Hope you like it. Please share your query below in the comment box. We will assist you.

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