Create a list of sequential dates

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.) Fill handle or the Fill command.

  1. 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.

  1. To create the list, do one of the following:
    • To use the fill handle, do the following:
      1. 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.

      2. 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 Button image and then click Fill Days, Fill Weekdays, Fill Months, or Fill Years.
    • To use the Fill command, do the following:
  1. 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.
  2. On the Home tab, in the Editing group, click Fill, and then click Series.

Excel Ribbon Image

  1. In the Series dialog box, under Date unit, click the unit that you want to use.
  2. 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.

 
 
Applies to:
Excel 2007