Modified Julian Day to Excel Serial Date

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

MJD
Excel
1 mjd (MJD) = -15017 excel (Excel)
Round to:
Step-by-Step Solution
1Write the conversion factor:
1 modified julian day = 1 excel
2Multiply the value by the conversion factor:
1 × 1 = -15017
3Result:
1 mjd (MJD) = -15017 excel (Excel)
↔ 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.

mjd to excel Table

mjdexcel
0 MJD-1.502e4 Excel
86400 MJD7.138e4 Excel
604800 MJD5.898e5 Excel
1765550511 MJD1.766e9 Excel

1 modified julian day in Other Units

Unit1 MJD =
Modified Julian Day to Unix Timestamp-3.5066304e9 Unix
Modified Julian Day to ISO 8601-3.5066304e9 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