Generating a series of Dates

Often you'll want ot 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 2016

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

Series in Excel 2016