Microsoft Office Tutorials and References
In Depth Information
Displaying any date
the mouse button and select an option from the shortcut menu (see Figure 16.2) — Fill
Days, Fill Weekdays, Fill Months, or Fill Years. Notice that Excel does not provide a Fill
Weeks option.
FIGURE 16.2
Using Auto Fill to create a series of dates
For more fl exibility enter the fi rst two dates in the series — for example, the starting day
for week 1 and the starting day for week 2. Then select both cells and drag the fi fill handle
down the column. Excel will complete the date series, with each date separated by the
interval represented by the fi rst two dates.
The advantage of using formulas (instead of Auto Fill) to create a series of dates is that
when you change the fi rst date, the others update automatically. You need to enter the
starting date in a cell and then use formulas (copied down the column) to generate the
additional dates.
The following examples assume that you enter the fi rst date of the series into cell A1
and the formula into cell A2. You can then copy this formula down the column as many
times as needed.
To generate a series of dates separated by seven days, use this formula:
=A1+7
Search JabSto ::




Custom Search