Create a list of sequential dates

Related topics

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Applies To

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel 2024 Excel 2024 for Mac Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2016

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

Use the Fill Handle

Select the cell that contains the first date. Drag the fill handle across the adjacent cells that you want to fill with sequential dates.
Select the 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.

Select the cell with the first date. Then select the range of cells you want to fill.
Select 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.

You can always ask an expert in the Excel Tech Community or get support in Communities.