XL2000: Dates Are Incorrect When You Fill a Very Large Time Frame (211991)

WORKAROUND

If you need to fill a range of dates, and the interval from the first date to the last date is greater than 2,730 years, use 2 or more steps, with each step filling no more than 2,730 years worth of dates.

For example, assume that you have a worksheet that contains the following dates and you want column A to be filled with dates at 5-year intervals, all the way down to 2/2/5000 (February 2, 5000 A.D.). Because the interval from the first date (2/2/2000) is more than 2,730 years from the last date (2/2/5000), use 2 steps as in the following example:

1. Select cells A1:A2.
2. Using the mouse, drag the fill handle located at the lower-right corner of cell A2 down to cell A500, and then release the mouse button.
   
   Cell A500 shows the date 2/2/4495. This is less than 2,730 years from the start date, 2/2/2000.
3. Select cells A499:A500.
4. Using the mouse, drag the fill handle located at the lower-right corner of cell A500 down to cell A601, and release the mouse button.
   
   Cell A601 shows the date 2/2/5000. This is less than 2,730 years from the start date for this fill, 2/2/4495.