A leap year, which occurs every four years, contains an additional day (February 29). Although the year 1900 was not a leap year, Excel treats it as such. In other words, when you type 2/29/1900 into a cell, Excel interprets it as a valid date and assigns a serial number of 60.

If you type 2/29/1901, however, Excel correctly interprets it as a mistake and doesn’t convert it to a date. Rather, it simply makes the cell entry a text string.

How can a product used daily by millions of people contain such an obvious bug? The answer is historical. The original version of Lotus 1-2-3 contained a bug that caused it to consider 1900 as a leap year. When Excel was released some time later, the designers knew of this bug and chose to reproduce it in Excel to maintain compatibility with Lotus worksheet files.

Why does this bug still exist in later versions of Excel? Microsoft asserts that the disadvantages of correcting this bug outweigh the advantages. If the bug were eliminated, it would mess up millions of existing workbooks.

In addition, correcting this problem would possibly affect compatibility between Excel and other programs that use dates. As it stands, this bug really causes very few problems because most users don’t use dates before March 1, 1900.

• How To Root Motorola Droid (Android 2.0.1) TEXT TUTORIAL: fbgstudios.com This tutorial works on both the original Android 2.0 Rom which ships with Droid, and the latest...
• How I Balance My Love Of Gadgets Between My Concern For The Environment And My Wallet. Each day in the U.S. alone, approximately 400,000 cell phones are discarded...thats about 146 million per year. Each one of...
• Verizon to launch 4G in up to 60 markets by mid-2012 Verizon to launch 4G in up to 60 markets by mid-2012 by Greg Kumparak on February 26, 2010 Everything moves...
• UK property prices take a fall in February. After a nine-month run of steady increases, UK house prices were reported to have fallen in February, while the three-month...
• Investment Strategies With $10,000 or less #1: CD Ladder Being a Financial Planner, I am always discussing different investment strategies with clients and colleagues. I would say that we...