Create a consecutive list of dates

  1. Type the first day or date in the list, for example Monday or 6/13/08, in a cell.
  2. Select the cell and use 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 to fill a list of consecutive days.

 Note   If the fill handle is not displayed, click Options on the Tools menu. On the Edit tab, select the Allow cell drag and drop check box.

  1. If you want only weekdays in your list or if you want to display dates with monthly or yearly intervals, click Auto Fill Options Button image and then select Fill Weekdays, Fill Months, or Fill Years.

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 2003