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 ﬂ exibility enter the ﬁ 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 ﬁ fill handle

down the column. Excel will complete the date series, with each date separated by the

interval represented by the ﬁ rst two dates.

The advantage of using formulas (instead of Auto Fill) to create a series of dates is that

when you change the ﬁ 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 ﬁ 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