Excel’s leap year bug
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.
// Related Posted - GOOGLE!
Related Websites
- Prosper.com and Your Emergency Fund I was reading an article on bankrate.com about Using a CD Ladder as Parking Locations for Your Emergency Fund. One...
- Cyanogen Nexus One Addon 0.1 – Makin` Bacon Released Cyanogen has released an expansion pack for the Google Nexus One titled “Nexus One Addon 0.1 – Makin` Bacon” Includes:...
- On This Date in Baseball History-March 15 1960- The Southern Association announces the New Orleans Pelicans, for the first time since 1901, will not be part of...
- Manup456’s Eclair (2.0.1) updated to v1.4 Manup456 has updated his Eclair 2.0.1 ROM from v1.3 to v1.4 today. Eclair_2.0.1-v1.4 Kernal BFS 313 (By Jac) ext3 and...
- Athlete Profiles: Serena Williams The youngest of the famous Williams sisters, Serena was born in 1981. She and her sister have made history many...
