Sure, it could be fixed. But it's a lot easier to let the false 1900 leap year live on in Excel.
Today I learned that Excel incorrectly assumes 1900 was a leap year, and Microsoft won't fix it because the whole house of ...
Microsoft's spreadsheet software, Excel, treats the year 1900 as a leap year, even though it wasn't actually one. Microsoft explains that this is for compatibility with older spreadsheet software, and ...
If you would like to improve your Excel workflows and spreadsheets and in the process save a huge amount of time you might be interested in mastering Excel date functions. Once mastered this knowledge ...