Create a consecutive list of dates
- 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 to fill a list of consecutive days.
Note If you want only weekdays in your list, click Auto Fill Options
and then select Fill Weekdays only.