Show All

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