Generating a series of Dates
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:
Choose Series... to open the Series dialog box:
Permission is granted for article quotations from OfficeToolTips, provided the direct link to the source articlehttp://www.officetooltips.com/excel 2016/tips/generating a series of dates.html