How to generate series of dates

Excel 2016 2013 2010 2007 2003
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 365

Choose Series... to open the Series dialog box:

Series in Excel 365

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 365

See also this tip in French: Comment créer une série de dates.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.