Microsoft KB Archive/247548

From BetaArchive Wiki
Knowledge Base


Article ID: 247548

Article Last Modified on 1/25/2007



APPLIES TO

  • MSPRESS Microsoft Excel 97 Step by Step, Advanced Topics ISBN 1-57231-564-4



This article was previously published under Q247548

SUMMARY

This article contains comments, corrections, and information about known errors relating to the Microsoft Press book Microsoft Excel 97 Step by Step, Advanced Topics, ISBN 1-57231-564-4.

The following topics are covered:

  • Page 69: 1900 Is Not A Leap Year


MORE INFORMATION

Page 69: 1900 Is Not A Leap Year

On Page 69, in the first paragraph, the last sentence states that 1900 was a leap year, so it had 366 days. This information is incorrect. This sentence should be deleted.

In addition, it should be noted that the year 1900 is not a leap year as the illustration at the top of the page indicates by the number 366. It should also be noted that Microsoft Excel treats 1900 as a leap year, and that this algorithm was adopted to maintain compatibility with dates in Lotus 1-2-3, and is by design.

For further information on this please see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q181370
TITLE: Microsoft Excel Incorrectly Assumes 1900 Is a Leap Year

Microsoft Press is committed to providing informative and accurate books. All comments and corrections listed above are ready for inclusion in future printings of this book. If you have a later printing of this book, it may already contain most or all of the above corrections.


Additional query words: EUBOOK EUSBS OFF97 XL 1-57231-564-4

Keywords: kbdocerr kbdocfix kbinfo KB247548