Microsoft Office Tutorials and References
In Depth Information
Entering a series of dates
When extending a series of dates, remember the following:
You can use the Series In options to choose whether to extend the selected date
across the current row or down the current column.
You can use the Step Value option to specify the interval between cells. For example,
by typing 2 in the Step Value text box and selecting Month in the Date Unit area, you
can create a series of dates occurring every other month. By typing a negative
number in the Step Value text box, you can create a series that decreases (goes backward
You can use the Stop Value text box to set an ending date for the series. Using this
method, you can use the Series command without having to figure out how many
cells to select in advance. For example, to enter a series of dates that extends from
3/1/2014 through 2/1/2015, type 3/1/2014 in a cell. Then select only that cell,
display the Series dialog box, select the Columns option, and type 2/1/2015 in the Stop
Value text box. Excel extends a series of dates following the original cell.
For more information about AutoFill and the Series command, see “Filling cells and creating
data series” in Chapter 8, “Worksheet editing techniques.”
Extending an existing date series
The AutoFill feature uses the selected cells to determine the type of series you intend to
create when you drag the ill handle. AutoFill copies text and nonsequential values and
increments sequential numeric values. Because dates are stored as serial values, AutoFill
extends them sequentially, as illustrated in Figure 15-3.
Figure 15-3 Starting with the values in the Selected Values area, we created the values to the
right by dragging the ill handle.