Row & columns

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.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Use the Fill Handle

  1. Select the cell that contains the first date. Drag the fill handle across the adjacent cells that you want to fill with sequential dates.

  2. Select the fill handle  Fill handle  at the lower-right corner of the cell, hold down, and drag to fill the rest of the series. Fill handles can be dragged up, down, or across a spreadsheet.

  3. Use the Fill handle to create a list of sequential dates

Use the Fill command

  1. Select the cell with the first date. Then select the range of cells you want to fill.

  2. Select Home > Editing > Fill > Series > Date unit. Select the unit 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.

×