Excel Serial Date to Modified Julian Day

Convert excel (Excel) to mjd (MJD) with formulas, examples, and conversion tables.

Excel
MJD
1 Excel = 15019 MJD
Full precision:15019 MJD
Step-by-Step Solution

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

1 excel serial date = 1 mjd

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

1 × 1 = 15019 mjd

So 1 excel = 15019 mjd.

✓Quick check: 15019 ÷ 1 = 1 excel
↔ Modified Julian Day to Excel Serial Date

How to Convert Excel to MJD

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

The Formula

MJD = Excel × 1

Key Fact

1 excel serial date = 1 mjd

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

Example Conversions

Example 1: 1 Excel = 15019 MJD
1 × 1 = 15019
Example 2: 5 Excel = 15023 MJD
5 × 1 = 15023
Example 3: 10 Excel = 15028 MJD
10 × 1 = 15028

Excel to MJD Table

ExcelMJD
0 Excel15018 MJD
86400 Excel101418 MJD
604800 Excel619818 MJD
1765163406 Excel1765178423.86 MJD

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