Create a list of sequential dates

You can quickly create a list of dates in sequential order by using the Fill Handle Fill handle or the Fill command.

  1. On a worksheet, select the cell in which you want to start the list of sequential dates, and then type the first day or date in the list.

    For example, type Monday or 6/15/08.

  2. To create the list, do one of the following:

    • To use the Fill Handle:

      1. 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 is displayed by default, but if it is not available, 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.

      2. To display days or weekdays only in your list, or to display dates with monthly or yearly intervals, after dragging the fill handle, click Auto Fill Options Button image and then click Fill Days, Fill Weekdays, Fill Months, or Fill Years.

        Use the Fill handle to create a list of sequential dates
    • To use the Fill command, do the following:

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

      2. On the Home tab, in the Editing group, click Fill, and then click Series.

        Fill options from Home > Editing > Fill

      3. In the Series dialog box, under Date unit, click the unit that you want to use.

        Excel Fill > Series options
      4. If you want to increase the increments that are used in the sequence and specify the end of the sequence, in the Step value and Stop value boxes, type the values that you want to use.

Tip: You can sort dates like any other data. By default, dates are sorted from the earliest date to the latest date.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

See Also

Fill data automatically in worksheet cells

Use AutoFill and Flash Fill

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×