Home Excel 2002 Dates Series Of Dates
Search MS Office A-Z | Search Web Pages/ Design A-Z
Series Of Dates
- To quickly enter a list of dates, enter the first one and format it as you’d like. Drag over a series of cells, starting with the one you filled in.
- Choose Edit, Fill, and Series.
- The dialog box lets you choose to make the dates ascend by days, weekdays only, months, or years.
- Click OK, and the dates will fill themselves in with the format you applied to the first one.