KitMul MarkKitMul Text

Convert Excel Dates to Human Dates

Convert Excel serial date numbers to human-readable dates and vice versa, handling the Lotus 1-2-3 leap year bug.

The Excel Date Converter provides fast, accurate processing of Excel serial date numbers directly in your browser. It correctly handles the infamous Lotus 1-2-3 leap year bug, supports bidirectional conversion between serial numbers and calendar dates, and processes everything locally with no server uploads for complete privacy. Ideal for data analysts, developers, accountants, and anyone working with spreadsheet date values.

Loading Converter...
Your data stays in your browser
Was this tool useful?
Tutorial

How to Use

1
1

Enter an Excel Serial Number

Type or paste an Excel serial date number (e.g. 45000) to convert it to a standard calendar date.

2
2

Switch to Date-to-Serial Mode

Toggle to 'Date to Excel Serial' mode and pick a date to find its corresponding Excel serial number.

3
3

Copy the Result

Click the copy button next to the result to paste it directly into your spreadsheet, code, or report.

Guide

Complete Guide to Excel Date Converter

What Is an Excel Serial Date?

Excel represents dates internally as serial numbers counting the days since January 1, 1900. Serial 1 is January 1, 1900, serial 2 is January 2, 1900, and so on. This system allows Excel to perform date arithmetic using simple integer operations. However, it carries a historical bug from Lotus 1-2-3 that incorrectly treats 1900 as a leap year.

The Lotus 1-2-3 Leap Year Bug

In 1983, Lotus 1-2-3 was coded with the assumption that 1900 was a leap year. It is not; leap years divisible by 100 must also be divisible by 400. When Microsoft created Excel, they deliberately replicated this bug to maintain file compatibility with Lotus spreadsheets. This means serial number 60 corresponds to the non-existent February 29, 1900. This tool detects and flags that edge case automatically.

How the Conversion Works

The formula starts from a base epoch of December 30, 1899 and adds the serial number in days. For serials 1 through 59 (dates before the phantom Feb 29), the tool subtracts one day to compensate for the bug. Serial 60 itself is flagged as invalid. Serials above 60 convert directly without adjustment. The reverse conversion applies the same logic in the opposite direction.

Best Practices for Working with Excel Dates

Always verify date columns after importing CSV or XLSX files; some tools export raw serial numbers instead of formatted dates. When migrating data between systems, convert serial numbers to ISO 8601 format (YYYY-MM-DD) as an intermediate step. Be aware that Google Sheets uses the same serial system, so conversions are directly compatible between the two platforms.

Sources

Examples

Worked Examples

Example: Convert Serial 45000 to a Calendar Date

Given: Excel serial number 45000.

1

Step 1: Enter 45000 in the serial number input field.

2

Step 2: The tool calculates (45000 - 25569) * 86400000 ms offset from Unix epoch.

3

Step 3: The result is displayed as 2023-03-15.

Result: Serial 45000 corresponds to March 15, 2023.

Example: Convert a Date to Excel Serial

Given: The date January 1, 2025.

1

Step 1: Switch to 'Date to Excel Serial' mode.

2

Step 2: Enter or pick 2025-01-01.

3

Step 3: The tool computes the number of days from the Excel epoch.

Result: January 1, 2025 corresponds to Excel serial 45658.

Use Cases

Practical Examples

Spreadsheet Data Import

“When importing CSV files that store dates as serial numbers, convert them to human-readable dates for analysis.”

Database Migration

“Legacy databases sometimes store dates as Excel serial numbers; convert them before migrating to a modern system.”

Financial Reporting

“Verify that date values in Excel financial models correspond to the correct calendar dates.”

Frequently Asked Questions

?What is an Excel serial date number?

An Excel serial date is an integer representing the number of days since January 1, 1900. For example, serial 1 is January 1, 1900 and serial 45000 is March 15, 2023.

?What is the Lotus 1-2-3 bug?

Lotus 1-2-3 incorrectly treated 1900 as a leap year, creating a phantom February 29, 1900. Excel preserved this bug for backward compatibility, so serial number 60 maps to a date that never existed.

?How does this tool handle the Lotus bug?

Serial 60 is flagged as the phantom date. For serials 1-59 the tool adjusts by one day so dates before March 1, 1900 are correct. Serials above 60 work without adjustment.

?Can I convert dates back to Excel serial numbers?

Yes. Switch to 'Date to Excel Serial' mode, enter a date, and the tool instantly produces the corresponding serial number compatible with Excel and Google Sheets.

?Does this work with Google Sheets dates?

Yes. Google Sheets uses the same serial date system as Excel, including the Lotus 1-2-3 bug, so conversions are fully compatible.

?Is my data kept private?

Absolutely. All conversions happen 100% in your browser. No data is ever sent to a server, making it safe for sensitive financial or personal dates.

?Is this tool free to use?

Yes, completely free with no limits, no sign-up, and no ads. Use it as many times as you need.

?What date formats are supported?

The tool outputs dates in ISO 8601 format (YYYY-MM-DD). For date-to-serial conversion, enter dates in the same format or use the date picker.

?What is the maximum serial number supported?

The tool supports any positive serial number. Practically, Excel supports dates from January 1, 1900 (serial 1) through December 31, 9999 (serial 2958465).

?Can I use this for Mac Excel dates?

Modern Mac Excel versions use the same 1900-based serial system. The older 1904 date system (which started from January 1, 1904) is no longer the default, but if you need 1904-system conversion, subtract 1462 from your serial first.

Help us improve

How do you like this tool?

Every tool on Kitmul is built from real user requests. Your rating and suggestions help us fix bugs, add missing features and build the tools you actually need.

Rate this tool

Tap a star to tell us how useful this tool was for you.

Suggest an improvement or report a bug

Missing a feature? Found a bug? Have an idea? Tell us and we'll look into it.

Related Tools

Unix Timestamp Converter

Convert Unix timestamps to human-readable dates and vice versa.

Try Tool

Seconds to H:M:S Converter

Convert seconds to hours, minutes, seconds and vice versa.

Try Tool

Convert 12h to 24h Time

Instantly convert between 12-hour (AM/PM) and 24-hour (military) time formats.

Try Tool
Recommended Reading

Recommended Books on Dates, Data & Spreadsheets

A Brief History of Time

A Brief History of Time

Stephen Hawking

The Order of Time

The Order of Time

Carlo Rovelli

Why Time Flies

Why Time Flies

Alan Burdick

As an Amazon Associate we earn from qualifying purchases.

Boost Your Capabilities

Professional Products for Data & Time Management

fenix 7X Pro Solar, Multisport GPS Smartwatch, Built-in Flashlight, Solar Charging Capability, Black

fenix 7X Pro Solar, Multisport GPS Smartwatch, Built-in Flashlight, Solar Charging Capability, Black

Garmin

Apple Watch Ultra 2 (GPS + Cellular, 49MM) - Black Titanium Case with Black Ocean Band (Renewed)

Apple Watch Ultra 2 (GPS + Cellular, 49MM) - Black Titanium Case with Black Ocean Band (Renewed)

Apple

CASIO G-Shock GBD-200-1JF [20 ATM Water Resistant G-Squad] Watch Shipped from Japan

CASIO G-Shock GBD-200-1JF [20 ATM Water Resistant G-Squad] Watch Shipped from Japan

Casio

As an Amazon Associate we earn from qualifying purchases.

Newsletter

Get Free Productivity Tips & New Tools First

Join makers and developers who care about privacy. Every issue: new tool drops, productivity hacks, and insider updates — no spam, ever.

Priority access to new tools
Unsubscribe anytime, no questions asked