📗 Excel 日期序号转换Excel Date Serial Converter

使用说明与常见问题How-to & FAQ

「Excel 日期序号转换」是什么？What is the Excel Date Serial Converter?

Excel/WPS 日期序列号（如 46023）与日期互相转换，支持 1900 和 1904 日期系统及时间小数。Convert Excel/Sheets date serial numbers (e.g. 46023) to dates and back, 1900 or 1904 system.

如何使用「Excel 日期序号转换」？How do I use the Excel Date Serial Converter?

在「Excel 日期序号转换」中，填写「序列号」、「或日期」、「日期系统」等参数，结果会随输入实时计算并显示在下方。In the Excel Date Serial Converter: Fill in "Serial number", "or Date", "System"; results are recalculated instantly as you type.

为什么 1900 年 2 月 29 日有问题？What's the 1900 leap-year bug?

Excel 为兼容 Lotus 1-2-3，把 1900 年当作闰年（实际不是），所以序列号 60 对应不存在的 1900-02-29；本工具对 60 之前的序列号和日期做了修正，序列号 60 会标注为虚构日期。For Lotus 1-2-3 compatibility Excel treats 1900 as a leap year, so serial 60 is the non-existent 1900-02-29; serials below 60 (and dates before 1900-03-01) are corrected here, and serial 60 is flagged as fictitious.

时区如何处理？How are time zones handled?

「Excel 日期序号转换」按 UTC（协调世界时）或纯日期计算，不受你设备时区和夏令时影响。The Excel Date Serial Converter works in UTC (or with plain calendar dates), so your device's time zone and daylight saving time do not affect the result.

「Excel 日期序号转换」免费吗？需要注册吗？Is the Excel Date Serial Converter free? Do I need an account?

「Excel 日期序号转换」完全免费，无需注册或安装，打开网页即可使用，手机和电脑都能用；输入的内容只在你的浏览器本地处理。The Excel Date Serial Converter is completely free with no sign-up or install and works on phones and desktops; what you enter is processed only in your browser.