Microsoft Office Tutorials and References
In Depth Information
Entering a series of dates
Figure 15-1 After you drag the ill handle to extend a date series, use the options menu to
adjust the series.
You can use the Series command to tend to a series of dates with a bit more flexibility than
with the ill handle. To use this approach, type the starting date, select the range of cells
you want to ill (including the starting date), click the Fill button in the Editing group on the
Home tab, and click Series to display the Series dialog box shown in Figure 15-2.
Figure 15-2 Use the Series dialog box to create date series.