← All exercises

Fill a date series

Incrementing dates with the fill handle

Write a date, then select 2 cells and drag the fill handle to extend a date series (day, month, year, week) — 8 guided steps.

Write the 2nd date in cell A3

1 / 8

Single date — write the 2nd date

Select the 2 dates, then drag the fill handle down to A15

2 / 8

Single date — fill down the series

Write the 2nd date in cell B3

3 / 8

One-month gap — write the 2nd date

Select the 2 dates, then drag the fill handle down to B15

4 / 8

One-month gap — fill down the series

Write the 2nd date in cell C3

5 / 8

One-year gap — write the 2nd date

Select the 2 dates, then drag the fill handle down to C15

6 / 8

One-year gap — fill down the series

Write the 2nd date in cell D3

7 / 8

One-week gap — write the 2nd date

Select the 2 dates, then drag the fill handle down to D15

8 / 8

One-week gap — fill down the series

Your score is

0%