Microsoft KB Archive/51960

Excel: Data Series Missing Date When Using Weekday Option PSS ID Number: Q51960 Article last modified on 01-26-1993 PSS database name: M_eXceL

2.20 3.00 | 2.x 3.00 | 2.20 2.21 3.00

MACINTOSH | WINDOWS | OS/2

Summary:

In Microsoft Excel, if you use a data series to create a row or column of weekdays and the first or last date indicated falls on a weekend, the series will be missing a date.

If the first date falls on a weekend, the date of the Monday following the weekend is omitted from the series. If the stop value given falls on a weekend, the date of the Friday preceding the stop value is omitted from the series.

This feature is by design. If you select Weekday, Excel displays dates that are only on a Monday through Friday. To display weekend dates also, select Day rather than Weekday.

Additional reference words: 2.10 2.10c 2.20 3.00 noupd

Copyright Microsoft Corporation 1993.