Modified Julian Day to Excel Serial Date

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

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

To convert 1 mjd to excel, we multiply by 1 because one modified julian day equals exactly 1 excel.

1 modified julian day = 1 excel

Since each modified julian day contains 1 excel, we multiply our value by this factor:

1 × 1 = -15017 excel

So 1 mjd = -15017 excel.

✓Quick check: -15017 ÷ 1 = 1 mjd
↔ Excel Serial Date to Modified Julian Day

How to Convert MJD to Excel

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

The Formula

Excel = MJD × 1

Key Fact

1 modified julian day = 1 excel

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

Example Conversions

Example 1: 1 MJD = -15017 Excel
1 × 1 = -15017
Example 2: 5 MJD = -15013 Excel
5 × 1 = -15013
Example 3: 10 MJD = -15008 Excel
10 × 1 = -15008

MJD to Excel Table

MJDExcel
0 MJD-15018 Excel
86400 MJD71382 Excel
604800 MJD589782 Excel
1765163406 MJD1765148387.85 Excel

1 Modified Julian Day in Other Units

Unit1 MJD =
Modified Julian Day to Unix Timestamp-3506630400 Unix
Modified Julian Day to ISO 8601-3506630400 ISO
Modified Julian Day to Julian Day2400001.5 JD
Modified Julian Day to Excel Serial Date-15017 Excel

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