Employment and Career Development Division
WorkSource logo

Consecutive Dates Automatically

 Process Aids
 Business Services
   Quick Guides
   Program Information
   Trainer's Toolbox
   Training Sites
   Assistive Technology
   SKIES Trainer's Corner
   Inside SKIES
 Additional Resources
   Contact Information
This short guide will show you how to automatically insert consecutive dates (days, weekdays only, months, years) into the cells of an Excel spreadsheet.

1.) This is an example of what we want to accomplish. You can choose any beginning date.
2.) Open up an Excel spreadsheet and enter your starting date in a cell.
3.) This next step can be a bit tricky, so don't get discouraged if you can't do it on your first attempt. Right click on the Fill Handle and drag the Fill Handle over the range of cells that you wish to insert dates into.
4.) When you get to the last cell in your range, let go of the right click on your mouse to reveal the customization menu. Select the appropriate date type.
5.) Here are examples of the four different date types.

ESD Logo

Copyright © 2010 Employment Security - All Rights Reserved