# Excel date > How do spreadsheet serial dates work? Spreadsheet serial numbers and calendar dates, in the 1900 or 1904 system. Convert a date and time to an Excel serial number or a serial number back to a date, in the 1900 or 1904 date system, including the 1900 leap day quirk. - Page: https://how.box/excel-date/ - Runs entirely in the browser. - License: HowToolbox's own text and data (titles, explanations, FAQs, tool descriptions and schemas, this file) are CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/); AI training and answers are welcome. Attribute "HowToolbox (how.box)" with a link to the page used. Third-party data keeps its own terms; the name and logo are not licensed. Publisher: HowToolbox, contact@how.box. Terms: https://how.box/about/terms/ ## Inputs Answer link: https://how.box/excel-date/?serial={serial}&direction={direction}&system={system}&date={date}&time={time} - `serial` (number 0 to 2.95846599998e6): Serial number. Example: `46326.5`. - `direction` (from_date or from_number): Convert. Example: `from_date`. - `system` (1900 or 1904): Date system. Example: `1900`. - `date` (text): Date (Gregorian). Example: `2026-10-31`. - `time` (text): Time (UTC, HH:MM:SS). Example: `12:00:00`. Example answer: https://how.box/excel-date/?serial=46326.5&direction=from_date&system=1900&date=2026-10-31&time=12%3A00%3A00 A complete link carries the primary answer in the page HTML; a missing or invalid value shows the default page. ## Agent tools - `excel_date_calculate`: Excel date: Fractions represent time of day. - MCP, one POST to https://how.box/mcp: `{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"excel_date_calculate","arguments":{"serial":46326.5,"direction":"from_date","system":"1900","date":"2026-10-31","time":"12:00:00"}}}` - GET: https://how.box/mcp/run/excel_date_calculate?serial=46326.5&direction=from_date&system=1900&date=2026-10-31&time=12%3A00%3A00 ## How it works Spreadsheet dates are numbers: the integer part counts days and the fraction counts time within the day. A fraction of 0.5 means noon. No time zone is attached to a spreadsheet serial. In the 1900 system, serial 1 is 1900-01-01. Excel deliberately preserves the old compatibility bug that treats 1900 as a leap year: serial 60 is the nonexistent 1900-02-29. In the 1904 system, serial 0 is 1904-01-01. Microsoft documents the 1462-day difference between systems for modern dates. Serial 61 in the 1900 system is 1900-03-01. The converter identifies serial 60 instead of silently turning it into a real date. Date input must be real; it cannot enter the fictional day. Fractions are displayed to the nearest second, capped at the last second of the serial day. ## FAQ **What does serial 60 mean?** In the 1900 system it is the fictional 1900-02-29, retained for compatibility. **Why do two workbooks differ by 1462 days?** They may use different date systems: 1900 and 1904. **What does the fraction mean?** It is a fraction of 24 hours: 0.5 is 12:00:00. **Does a serial include a time zone?** No. UTC is used here as a neutral clock label; no time-zone shift is applied. **Can I enter 1900-02-29 as a date?** No. It is not a real Gregorian date. Enter serial 60 to inspect the spreadsheet bug. More: [HowToolbox index](https://how.box/llms.txt) · [Agent Skill](https://how.box/skill.md) · [agent terms](https://how.box/about/agents/)