Create a list of sequential dates
You can quickly create a list of dates, in sequential order, by using the Fill Handle
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
-
Use the Fill command
-
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.
Need more help?
You can always ask an expert in the Excel Tech Community or get support in Communities.
See Also
Need more help?
Want more options?
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
