How to create a list of sequential dates in Excel

  1. Click on “Excel”, select a workbook to edit
  2. Select the cell that contains the first date
  3. Then select the range of cells you want to fill
  4. Click “Home”
  5. Go to the “Editing” section and click on the “Fill” dropdown button
  6. Click “Series”
  7. Under “Date unit”, select the unit you want to use
  8. Click “OK”
  9. You have successfully created a list of sequential dates in Excel