How to Create Automatic Rolling Months in Excel?
Last Updated :
16 Oct, 2022
Microsoft created the spreadsheet Excel for Windows, macOS, Android, and iOS. Excel offers calculation, computation, visualization tools, pivot tables, and VBA. You will find a lot of cells in a spreadsheet. The names of the rows and the columns are both written in alphabetical order. The row and column addresses of each cell can be used to pinpoint its precise location. The spreadsheet’s first top-left cell is A1. One spreadsheet contains 16384 columns and 1048576 rows in total (A to XFD).
Automatic Rolling Months in Excel
There are several ways to set up a series of Automatic Rolling Months:
Using the Excel Toolbar’s Fill Option
By using the Fill Option from the Excel Toolbar, you can create a series of dates with automatic rolling months.
Step 1: Enter the first date of the series in a cell. For instance, in cell C6, enter September 23, 2022:

Automatic Rolling Months in Excel
Step 2: Select all of the cells where you want the series to be inserted. Cells C6 to C17 were selected here:

Automatic Rolling Months in Excel
Step 3: Then, in the Editing Section of the Excel Toolbar, select Home>Fill. Select an option from the drop-down menu:

Automatic Rolling Months in Excel
Step 4: Select Series from the available options:
Step 5:
- A dialogue box called Series will appear:
- Select Columns from the Series in options.
- Then, under Type, select Date.
- Then, in the Date unit drop-down menu, select Month.
- And then enter 1 in the Step value box.
Step 6: Finally, click on OK. This is how the monthly dates roll:
Using Excel Formula
Excel formulas can also be used to generate a series of dates rolling by months. The steps are as follows:
Step 1: Enter the first date after selecting a cell. For instance, select C6 and enter the date September 23, 2022:
Step 2: Then enter this formula into cell C7:
=DATE(IF(MONTH(C6)+1>12,YEAR(C6)+1,YEAR(C6)),IF(MONTH(C6)+1>12,MOD(MONTH(C6)+1,12),MONTH(C6)+1),DAY(C6))

Automatic Rolling Months in Excel
Step 3: Drag the Fill Handle to the series cell. For instance, let’s drag it to C17 and all the cells are filled with automatic rolling months:
Using Fill Handle
Using Fill Handle is the easiest way for Automatic Rolling Month in Excel. The steps are as follows:
Step 1: The first date of the series should be in a specified cell. Cell C6 has the date 23 September 2022:
Step 2: Drag the Fill Handle to the desired series length. A Series of 14 cells up to C19 was created here. Now select Fill Months from the Auto Fill Options:
Step C: Finally, all the cells will be filled with automatic rolling months:

Similar Reads
How to Create a Rolling Chart in Excel?
A chart range is a data range that automatically updates as the data source is changed. This dynamic range is then utilized in a graphic as the source data. As the data changes, the dynamic range updates instantaneously, causing the chart to refresh. A common necessity when developing reports in Exc
3 min read
How to Create Automatically Extended Plot Ranges in Excel?
We can easily create charts with the help of data points and data sources. But, If we have more data points added to our data source we need our chart will get updated depending upon our data source. For example, if we want to plot a sales chart on monthly basis, we need to update our chart every ti
2 min read
How to Create a Line Chart in Excel
Line graphs are a highly valuable tool in Excel, helping users analyze trends and patterns effectively over time. They are widely used for time-series analysis in Excel, allowing a clear visual representation of changes in data. In this guide, you'll learn how to create a line graph in Excel, includ
10 min read
How to Create a Timeline or Milestone Chart in Excel?
A timeline is a type of chart that visually shows a series of events in chronological order over a linear timescale. The power of a timeline is that it is graphical, which makes it easy to understand critical milestones, such as the progress of a project schedule. Benefits of using Timeline / Milest
2 min read
How to Create a Thermometer Chart in Excel?
The Thermometer chart in Excel can be used to depict specific data based on the actual value and the target value. It can be used in a wide range of scenarios such as representing the past performance of horses in horse racing or the global temperature and it's variation throughout decades etc. In t
2 min read
How to Create Multi-Category Charts in Excel?
The multi-category chart is used when we handle data sets that have the main category followed by a subcategory. For example: "Fruits" is a main category and bananas, apples, grapes are subcategories under fruits. These charts help to infer data when we deal with dynamic categories of data sets. By
3 min read
How to Create a Step Chart in Excel
A step chart is used to represent data that changes irregularly between time intervals. Now, Excel doesn't have a feature to create a Step Chart like the one shown below but we can create one by making some changes in our data. What is a Step Chart in ExcelA Step chart is the same as a Line Chart. T
4 min read
How To Create Interactive Charts in Excel?
In MS Excel, we can draw various charts, but among them today, we will see the interactive chart. By name, we can analyze that the chart, which is made up of interactive features, is known as an interactive chart. In general, this chart makes the representation in a better and more user-friendly way
9 min read
How to Automatically Insert Date and Timestamp in Excel?
The Date and Timestamp is a type of data type that determines the date and time of a particular region. It contains some characters along with some encoded data. This format may vary from language to language. Keeping track of date and time helps in managing records of our work as well as segregate
4 min read
How to Calculate Rolling Correlation in Python?
Correlation generally determines the relationship between two variables. The rolling correlation measure the correlation between two-time series data on a rolling window Rolling correlation can be applied to a specific window width to determine short-term correlations. Calculating Rolling Correlatio
2 min read