Need help setting this up?
If you'd rather not deal with the technical side, we can fully set up and manage your Microsoft 365 for you — including email, DNS, and ongoing support.
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.
Use the Fill command
-
Select the cell with the first date. Then select the range of cells you want to fill.
-
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.
Related Guides
- Split text into different columns with the Convert Text to Columns Wizard
- Import or export text (.txt or .csv) files
- Insert or delete cells, rows, and columns
- Collaborate on Word documents with real-time co-authoring
- OneDrive basics
Prefer us to handle this?
We provide fully managed Microsoft 365 setup and support — so you can focus on running your business.
