Excel Formulas to Create the Series of Dates by Month ~ Simple Guide!!

So far we have learned the formulas to create the series of dates by day in Excel. Similarly, here we will show the easiest way to generate a dynamic series of dates with a formula that increases by one month from a single start date in Excel. Let’s step into this article!! Get an official version of ** MS Excel** from the following link: https://www.microsoft.com/en-in/microsoft-365/excel

General Formula:

If you want to generate a dynamic series of dates by month, you can use the below formula.

=DATE(YEAR(date),MONTH(date)+1,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.

Example:

Let’s consider the below example image.

Here we will enter the starting date in Column C.
Now we are going to create a dynamic series of dates by month using this single start date.

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

Finally, you will get the result as shown below.

Bottom-Line:

Hope you like this article on how to generate the series of dates by month in Excel. If you have any other ideas or question , do share with us here in the comments section below.

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