How to generate series of dates
Excel
365
Often you'll want to insert a series of dates into a worksheet. The most efficient way to enter a series of dates doesn't require any formulas - just use Excel's AutoFill feature.
To generate a series of dates, do the following:
1. Enter the first date.
2. Drag the cell's fill handle while pressing the right mouse button (right-drag the cell's fill handle).
3. Release the mouse button and select an option from the shortcut menu:
![Data Series in popup in Excel for Microsoft 365 Data Series in popup in Excel 365](/images/tips/169_365/1.png)
Choose Series... to open the Series dialog box:
![Series in Excel for Microsoft 365 Series in Excel 365](/images/tips/169_365/2.png)
For example, if the Step value is 3, and in the Date unit section, the Month option is selected:
![The example of Series in Excel for Microsoft 365 The example of Series in Excel 365](/images/tips/169_365/3.png)
See also this tip in French: Comment créer une série de dates.