Excel Serial Date to ISO 8601

Convert excel (Excel) to iso (ISO) with formulas, examples, and conversion tables.

Excel
ISO
1 Excel = -2209075200 ISO
Full precision:-2209075200 ISO
Step-by-Step Solution

To convert 1 excel to iso, we multiply by 1 because one excel serial date equals exactly 1 iso.

1 excel serial date = 1 iso

Since each excel serial date contains 1 iso, we multiply our value by this factor:

1 × 1 = -2209075200 iso

So 1 excel = -2209075200 iso.

✓Quick check: -2209075200 ÷ 1 = 1 excel
↔ ISO 8601 to Excel Serial Date

How to Convert Excel to ISO

To convert excel to iso, multiply the value by 1.

The Formula

ISO = Excel × 1

Key Fact

1 excel serial date = 1 iso

Tip: To convert iso back to excel, divide by 1.

Example Conversions

Example 1: 1 Excel = -2209075200 ISO
1 × 1 = -2209075200
Example 2: 5 Excel = -2208729600 ISO
5 × 1 = -2208729600
Example 3: 10 Excel = -2208297600 ISO
10 × 1 = -2208297600

Excel to ISO Table

ExcelISO
0 Excel-2209161600 ISO
86400 Excel5255798400 ISO
604800 Excel5.0046e+10 ISO
1765163406 Excel1.5251e+14 ISO

1 Excel Serial Date in Other Units

Unit1 Excel =
Excel Date to Unix Timestamp-2209075200 Unix
Excel Serial Date to ISO 8601-2209075200 ISO
Excel Serial Date to Julian Day2415019.5 JD
Excel Serial Date to Modified Julian Day15019 MJD

Related Conversions

Unix Timestamp to Julian DayJulian Day to Unix TimestampUnix Timestamp to Excel DateExcel Date to Unix TimestampUnix Timestamp to Modified Julian DayModified Julian Day to Unix Timestamp