3 ms·

Excel being the de facto standard, Sheets has to try to be compatible with it, quirks and all.

• 2fast4you 6y ago
  Speaking of quirks, Excel still incorrectly assumes the year 1900 is a leap year. Even Excel has to try to be compatible with Excel. https://docs.microsoft.com/en-us/office/troubleshoot/excel/wrongly-assumes-1900-is-leap-year https://docs.microsoft.com/en-us/office/troubleshoot/excel/w...
  • eru 6y ago
    Microsoft even tried to get that quirk into the official standard.
  • phonon 6y ago
    You think that's bad...try to use a date function with a year before 1900...