Office
Sign in
Create a list of sequential dates

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.

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:

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

  2. 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 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 popup window, under Date unit, click the unit that you want to use.

    Excel Fill > Series options
  4. 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.

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

×