MS Excel incorrectly assumes that the year 1900 is a leap year.Surprisingly, Excel does have a few bugs; this is one of its most famous.It actually started because Lotus 123 counted 1900 as a leap year. Excel used the same serial date system used by Lotus 123, thereby making it easier for users to move spreadsheets from one program to the other.Although this bug could be corrected, many problems would ensue as a result, including almost all dates in Excel worksheets being decreased by one day. With 1900 as a leap year, the only incorrect dates are prior to March 1, 1900. As a result, the folks at Microsoft decided to include this bug in all the later versions of Excel. - Study24x7
Social learning Network
25 Feb 2019 11:00 AM study24x7 study24x7

MS Excel incorrectly assumes that the year 1900 is a leap year.

Surprisingly, Excel does have a few bugs; this is one of its most famous.It actually started because Lotus 123 counted 1900 as a leap year. Excel used the same serial date system used by Lotus 123, thereby mak...

See more

study24x7
Write a comment
Related Questions
500+   more Questions to answer
Most Related Articles