Transform

Convert human calendar dates into numeric Excel serial day numbers

Convert standard calendar dates into Excel-compatible numeric serial day values.

🛡️ Your rows never leave your browser.

Why Onfyt: Computes exact fractional serial values for timestamps down to the second for precision financial calculations.

Interactive Sample Data

id	order_date	total
1	2024-10-05	1200.00
2	2024-10-06 12:00:00	850.50
3	2024-11-04	3400.00

How this tool works

While human users prefer readable dates like '2024-10-05', certain legacy financial engines, automated VBA macros, and actuarial models require dates to be formatted as pure numeric Excel serial values. When feeding bulk data into older enterprise spreadsheet systems that lack automatic text-to-date coercion, providing dates as raw serial numbers prevents import errors and formula breakdown. An Excel serial number represents the continuous count of days since December 30, 1899. A whole integer represents midnight at the beginning of the day, while fractional decimals represent the portion of the 24-hour day elapsed (for example, 0.5 represents 12:00 PM noon, and 0.25 represents 6:00 AM). DataFix parses calendar dates and timestamps in any format, evaluates the exact elapsed time against the Excel 1900 epoch, and computes the precise floating-point serial value. This ensures 100% fidelity when importing files into specialized spreadsheet models and macro-enabled workbooks. Converting calendar dates into Excel numeric serial counts (days elapsed since January 1, 1900) ensures full mathematical formula compatibility in legacy spreadsheets.

Things that usually go wrong

Dates before 1900-03-01 produce serials below 60 — these are affected by Excel's 1900 leap-year bug.
Dates in non-ISO format must be standardised first.

Edge cases we tested

🧪 Dates with exact seconds ('2024-10-05 12:30:45')

Converted to high-precision decimal serial values without rounding loss.

🧪 Leap year calendar dates

Properly synchronized with Excel's 1900 date system.

🧪 Ambiguous date strings ('05/10/2024')

Configurable between US (MM/DD) and International (DD/MM) parsing.

Frequently Asked Questions

Why would I need Excel date serials?

When building Excel files programmatically (e.g. with Python's openpyxl), date cells must be set as serial integers, not strings.

Is the 1900 leap-year bug emulated?

Yes. The output matches what Excel would show for the same date.

Why does my Python openpyxl date look wrong after setting it as a serial?

openpyxl expects the date as a Python datetime object, not a serial integer. Use this tool to verify the expected serial, then set the cell value as a datetime in Python for correct display.