You can quickly create a list of dates in sequential order by using the fill handle (fill handle: The small black square in the lower-right corner of the selection. When you point to the fill handle, the pointer changes to a black cross.) or the Fill command.
- On a worksheet, select the cell in which you want to start the list of sequential dates, and then type the first day or date in the list.
Tip For example, type Monday or 6/15/08.
- To create the list, do one of the following:
- To use the fill handle, do the following:
To use the Fill command, do the following:
- Select the cell that contains the first date, and then drag the fill handle across the adjacent cells that you want to fill with the list of sequential dates.
Note The fill handle is displayed by default, but if it is not available, you must first set an option in Excel to enable the fill handle. For information about how to display the fill handle, see Display or hide the fill handle.
- To display days or weekdays only in your list, or to display dates with monthly or yearly intervals, after dragging the fill handle, click Auto Fill Options and then click Fill Days, Fill Weekdays, Fill Months, or Fill Years.
- Starting with the cell that contains the first date, select the range of cells that you want to fill with the sequential list of dates.
- On the Home tab, in the Editing group, click Fill, and then click Series.
- In the Series dialog box, under Date unit, click the unit that you want to use.
- If you want to increase the increments that are used in the sequence and specify the end of the sequence, in the Step value and Stop value boxes, type the values that you want to use.
Tip You can sort dates like any other data. By default, dates are sorted from the earliest date to the latest date.