BUG: 1900 Feb 29th is a valid date for MS Excel 2007 but it is not existing
I have found a bug on MS Excel 2007: the date 1900 Feb 29th is present as a valid date (serial number = 60), but 1900 (as well as all years divisible by 100, but not by 400) is not a leap year.
To find it, plase enter 01.01.1900 in A1 cell and then A2 = A1+1, A3 = A2+1, etc...
Is this a known bug?
Solutions to the Problem BUG: 1900 Feb 29th is a valid date for MS Excel 2007 but it is not existing
This is by design; this error has been present in all versions of Excel for Windows.
When Microsoft introduced Excel for Windows in 1987, Lotus 1-2-3 was the dominant spreadsheet program, and Lotus 1-2-3 counted 1900 as a leap year.
To win over Lotus customers, Excel had to be 100% compatible with it, so the developers deliberately built
this error into Excel too.
Once Excel had become the major spreadsheet program, there were so many workbooks in use that removing the error would break many existing spreadsheets, so it was left, and it's unlikely that it will be removed.
Using Windows troubleshooter:
- Click on Search on Charm bar and type Troubleshooting. Click on the very first option.
- A new window will open. Click View all from the left pane.
- Scroll down to the bottom and click on Windows update.
- Troubleshooter window for Windows update will pop up. Click on NEXT. It may ask you for administrative permission.
- The troubleshooter will automatically detect problems and fix it.
- Now, close this window and try download/install the app which was previously showing error.
Recommended Method to Fix the Problem: BUG: 1900 Feb 29th is a valid date for MS Excel 2007 but it is not existing:
How to Fix BUG: 1900 Feb 29th is a valid date for MS Excel 2007 but it is not existing with SmartPCFixer?
1. Download Error Fixer . Install it on your computer. Click Scan, and it will perform a scan for your computer. The junk files will be shown in the list.
2. After the scan is done, you can see the errors and problems which need to be repaired.
3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.
Related: How to Download Toshiba Portege R500 HDD/SSD Alert Utility v.22.214.171.124 driver,Way to Update & Download Toshiba Satellite A355-S69403 Motorola Modem Region Select Utility v.126.96.36.199 driver,Where to Download Toshiba Satellite L305-S5926 HW Setup Utility v.2.00.11 driver,[Solved] Download Toshiba Satellite L675-S7115 Laptop Checkup v.188.8.131.52 driver,Method to Download Toshiba Satellite M645-S4080 Media Controller v.184.108.40.206 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: Troubleshooting:BSOD, freeze , sudden crashes.,By mistake I have blocked the installation of Software from Adobe System Incorporated. Error: This publisher has been blocked from running software on your machine [Anwsered],[Solution] BSOD Help PLEASE!,Troubleshoot:BSOD driver irql not less or equal netio.sys,How to Fix - cabinet file FINDSTE.CAB has an invalid digital signature???,All diagnostic tools give 0x800700C1, troubleshooting wizard can't continue,all files try to open with adobe,all icons on desktop have changed to Adobe icon and won't open,All functions of my outlook are working except it will not let me "REPLY" or start a "NEW" email,all f1-f12 shortcuts not work