blocks|key|1922381|text|不，它不是Excel中的一个bug，是的，您遗漏了一些东西。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1922382|Excel实现了与Lotus1-2-3匹配的日期，当时需要兼容，因此设计时会出现此错误。莲花1-2-3曾一度认为1900年是闰年.|1922383|请参阅微软的文档，其原因是为什么不修复它。|offset|length|1922384|entityMap|0|LINK|mutability|MUTABLE|url|http://support.microsoft.com/kb/214326^0|0|0|6|2|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

No, it is not a bug in Excel and yes you are missing something.

Excel implemented the dates to match with Lotus 1-2-3 for which compatibility was required at the time so was designed to have this error. Lotus 1-2-3 had the bug of thinking 1900 was a leap year.

See Microsoft's <a href="http://support.microsoft.com/kb/214326" rel="nofollow noreferrer">documentation</a> for the reasons why not to fix it.

blocks|key|1192690|text|这不是错误-+Excel接受1900年2月29日为有效日期。这是一个历史性的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1192691|你的60天被认为是“1900年1月1日以来的天数”。|1192692|更多信息：|1192693|http://polymathprogrammer.com/2009/10/26/the-leap-year-1900-bug-in-excel/|offset|length|1192694|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|21|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|T|8|@]|9|@$H|U|I|V|1|W]]|A|$]]|$1|J|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|G]]]]

It's not a bug - Excel accepts Feb 29th 1900 as a valid date. It's a historical issue. 

Your 60 is being regarded as 'number of days since Jan 1 1900'.

More info:

<a href="http://polymathprogrammer.com/2009/10/26/the-leap-year-1900-bug-in-excel/" rel="nofollow">http://polymathprogrammer.com/2009/10/26/the-leap-year-1900-bug-in-excel/</a>

blocks|key|2401262|text|请。是个虫子。它从未记录在最初的Excel+for+Windows规范中。最初的Excel是在任何Windows平台上的Mac年前使用的基于1904年的日期系统。最初的Excel作者确实认识到了这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2401263|“严格地说，这并不是Excel+1.0的问题，它只在Mac上运行。最初版本的Mac(和Excel)支持日期从1904年开始，部分原因是为了避免1900年不是闰年的问题。直到Excel移植到Windows+(Excel2.0)之后，才引入了1900年的日期系统，所以你不能把这个决定归咎于1.0团队(当然，我们在采访中不会对此置评)。”https://www.geekwire.com/2015/recalc-or-die-30-years-later-microsoft-excel-1-0-vets-recount-a-project-that-defied-the-odds/说。|blockquote|offset|length|2401264|这个bug也出现在MS和Multiplan上。|2401265|entityMap|0|LINK|mutability|MUTABLE|url|https://www.geekwire.com/2015/recalc-or-die-30-years-later-microsoft-excel-1-0-vets-recount-a-project-that-defied-the-odds/^0|0|4N|3F|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@$E|S|F|T|1|U]]|A|$]]|$1|G|3|H|5|6|7|V|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|J|$K|$5|L|M|N|A|$O|P]]]]

Please. It is a bug. It was never documented in the original Excel for Windows specifications. The original Excel which was on the Mac years before it was on any Windows platform used a 1904-based date system. The original Excel authors did recognize the issue. 

<blockquote>
 "Strictly speaking, that wasn't an issue with Excel 1.0, which ran only on Macs. The original version of the Mac (and Excel) supported dates starting in 1904, partly to avoid the issue with 1900 not being a leap year. It wasn't until Excel was ported to Windows (Excel 2.0) that the 1900 date system was introduced, so you can't blame any of us on the Excel 1.0 team for the decision (and so, of course, we wouldn't comment on it in the interview)."
 <a href="https://www.geekwire.com/2015/recalc-or-die-30-years-later-microsoft-excel-1-0-vets-recount-a-project-that-defied-the-odds/" rel="nofollow noreferrer">https://www.geekwire.com/2015/recalc-or-die-30-years-later-microsoft-excel-1-0-vets-recount-a-project-that-defied-the-odds/</a>
</blockquote>

The bug was also on MS-BASIC and Multiplan.

Please don't ask how I stumbled upon this but please try the following:

<ol>
<li>Type "60" into a cell in Excel.</li>
<li>Set the data type to a date format</li>
<li>The date displayed (in my case at least) is February 29th, 1900.</li>
</ol>

However, February 29th, 1900 never occurred since 1900 was not a leap year (see <a href="http://en.wikipedia.org/wiki/February_29" rel="noreferrer">Wikipedia</a>).

Is this a bug or am I missing something?

Is there a bug in Excel concerning dates?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

请不要问我是如何偶然发现的，但请尝试以下几点：在Excel中的单元格中键入"60“。将数据类型设置为日期格式所显示的日期(至少在我的例子中)是1900年2月29日。然而，1900年2月29日从没有发生过，因为1900年不是闰年(见)。这是窃听器还是我漏掉了什么？

问Excel中有关于日期的错误吗？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Excel中有关于日期的错误吗？EN