Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

View products that this article applies to.


When you fill a large range of cells from a cell that is formatted with the Date format, the dates in the filled range are not incremented as you expect.

↑ Back to the top


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.

↑ Back to the top


Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

Keywords: KB215193, kbprb, kbpending, dftsdahomeportal

↑ Back to the top

Article Info
Article ID : 215193
Revision : 4
Created on : 9/18/2011
Published on : 9/18/2011
Exists online : False
Views : 32