Excel Formulas to Create a Series of Dates by Year ~ Complete Guide!!
Tags: excelformula, excelformulas
Published: 2021-06-01 11:35:42

---
title: Excel Formulas to Create a Series of Dates by Year ~ Complete Guide!!
published: true
date: 2021-05-31 14:46:39 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-create-a-series-of-dates-by-year/
---

So far, we have already seen how to generate a **[series of dates by day](https://geekexcel.com/formulas-to-count-dates-by-day-of-week-in-excel-office-365/)** and **[month](https://geekexcel.com/excel-formulas-to-create-the-series-of-dates-by-month-simple-guide/)**. 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](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Series of dates by year](https://geekexcel.com/wp-content/uploads/2021/05/Series-of-dates-by-year.png)](https://geekexcel.com/excel-formulas-to-create-a-series-of-dates-by-year/series-of-dates-by-year/#main)<figcaption id="caption-attachment-45879">Series of dates by year</figcaption>

## Generic Formula:

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

**=[DATE](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)([YEAR](https://geekexcel.com/how-to-use-year-function-in-excel-365/)(date)+1,[MONTH](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)(date),[DAY](https://geekexcel.com/how-to-use-excel-day-function-in-office-365-with-examples/)(date))**

## Syntax Explanations:

- **DATE ** – This function will combine three different values and returns them as a date. Read more on the [**DATE function**](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/).
- **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](https://geekexcel.com/how-to-use-year-function-in-excel-365/)**.
- **MONTH**  – In Excel, the **[MONTH function](https://geekexcel.com/how-to-use-month-function-in-microsoft-excel-365/)** 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](https://geekexcel.com/how-to-use-excel-day-function-in-office-365-with-examples/)**.
- **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.

![Input Range](https://geekexcel.com/wp-content/uploads/2021/05/Input-Range-46.png)<figcaption id="caption-attachment-45881">Input Range</figcaption>

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

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-106.png)<figcaption id="caption-attachment-45880">Enter the formula</figcaption>

- Finally, you will get the result as shown below.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-99.png)<figcaption id="caption-attachment-45878">Result</figcaption>

## 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](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Related Articles:

- **[Excel Formulas to Calculate the Working days per Month ~ Simple Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-working-days-per-month/)**
- **[Excel Formulas to Find the Remaining Working Days in a Month!!](https://geekexcel.com/excel-formulas-to-find-the-remaining-working-days-in-a-month/)**
- **[How to Find the Actual Price of the Discounted Price in Excel 365?](https://geekexcel.com/how-to-find-the-actual-price-of-the-discounted-price-in-excel-365/)**
- **[Excel Formulas to Generate a Series of Dates by Custom Days ~ Easily!!](https://geekexcel.com/excel-formulas-to-generate-a-series-of-dates-by-custom-days/)**