You can quickly create a list of dates, in sequential order, by using the Fill Handle or the Fill command.
On a worksheet, select the cell in which you want to start the list of sequential dates, and then enter the first day or date in the list. For example, enter"Monday" or "6/15/08".
To create the list, either use the fill handle or fill command. See the explanation for each below.
To use the Fill Handle:
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 should appear automatically. If it isn't available, then 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.
After dragging the fill handle, you can display days or weekdays only in your list—or to display dates with monthly or yearly intervals. Click Auto Fill Options , and then click Fill Days, Fill Weekdays, Fill Months, or Fill Years.
To use the Fill command, do the following:
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.
On the Home tab, in the Editing group, click Fill, and then click Series.
In the Series popup window, under Date unit, click the unit that you want to use.
To increase the size of the increments in the sequence—and specify the end of the sequence: In the Step value and Stop value boxes, enter the values that you want to use.
Tip: You can sort dates much like any other data. By default, dates are sorted from the earliest date to the latest date.