KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

Q247548: Excel 97 Step by Step, Advanced Topics Comments and Corrections

Article: Q247548
Product(s): Microsoft Press
Version(s): 
Operating System(s): 
Keyword(s): kbdocfix kbdocerr
Last Modified: 16-FEB-2000

-------------------------------------------------------------------------------
The information in this article applies to:

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

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          : kbdocfix kbdocerr 
Technology        : kbMSPressSearch
Version           : :
Issue type        : kbinfo

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.