Microsoft Office Tutorials and References
In Depth Information
Generating a Series of Dates
Generating a Series of Dates
If you work with time-based data, you might want to insert a series of dates into a worksheet. For
example, in a sales tracking application, you might want to enter a series of dates for a sales
quarter — making sure, of course, to skip dates that occur during weekends.
Using AutoFill
The most efficient way to enter a series of dates doesn’t require any formulas — just use the
AutoFill feature to insert a series of dates. Enter the first date and then drag the cell’s fill handle
while pressing the right mouse button (right-drag the cell’s fill handle). Release the mouse button
and choose a command from the shortcut menu (see Figure 108-1).
In some situations, you need to enter two dates before you use the AutoFill. For example, if you
want to enter a series of dates that represent consecutive Mondays, you need to enter the first
two dates of the series. Then select both dates, right-click, and choose Fill Days from the shortcut
menu.
Figure 108-1: Using AutoFill to create a series of dates.
Using formulas
Another way to enter a series of dates is to use formulas. The advantage of using formulas
(rather than the AutoFill feature) to create a series of dates is that you can change the first date,
and the others are updated automatically. Enter the starting date into a cell and then use
formulas (copied down the column) to generate the additional dates.
 
Search JabSto ::




Custom Search