XL: Dates Are Not Incremented Properly When You Fill Large Ranges (215193)

WORKAROUND

To work around this behavior, use the Series command to fill large ranges with dates. To do this, follow these steps:

1. Start Microsoft Excel, and create a new, blank workbook.
2. Click the cell that you want to format with Date formatting.
3. On the Format menu, click Cells.
4. On the Number tab, click Date in the Category list.
5. In the Type list, click the date format that you want, and then click OK.
6. Type the number that you want in the cell that you formatted with the Date format, and then press ENTER.
7. Click the cell from step 6.
8. On the Edit menu, point to Fill, and then click Series.
   
   Notice that the Series dialog box appears.
9. Under Series in, click Rows if you want to fill a row, or click Columns if you want to fill a column.
10. Under Type, click Date, and then under Date unit, click the date format that you want.
11. In the Step value box, type the number by which you want to increment the series.
12. In the Stop value box, type the number that you want to use as the end value of the series.
13. Click OK.

Notice that the series is filled with dates, and that the dates are incremented correctly throughout the series.