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
| The information in this article applies to: |
| - Microsoft Excel for the Macintosh, versions 2.2 and 3.0 - Microsoft Excel for Windows, versions 2.x and 3.0 - Microsoft Excel for OS/2, version 2.2, 2.21, and 3.0 |
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.
