- Type the first day or date in the list, for example Monday or 6/13/08, in a cell.
- 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.) 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.
- If you want only weekdays in your list or if you want to display dates with monthly or yearly intervals, click Auto Fill Options 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.