Excel Serial Date to Modified Julian Day

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

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

excel to mjd Table

excelmjd
0 Excel1.502e4 MJD
86400 Excel1.014e5 MJD
604800 Excel6.198e5 MJD
1765550511 Excel1.766e9 MJD

1 excel serial date in Other Units

Unit1 Excel =
Excel Date to Unix Timestamp-2.2090752e9 Unix
Excel Serial Date to ISO 8601-2.2090752e9 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