Excel Serial Date to Julian Day

Convert excel (Excel) to jd (JD) with formulas, examples, and conversion tables.

Excel
JD
1 excel (Excel) = 2415019.5 jd (JD)
Round to:
Step-by-Step Solution
1Write the conversion factor:
1 excel serial date = 1 jd
2Multiply the value by the conversion factor:
1 × 1 = 2415019.5
3Result:
1 excel (Excel) = 2415019.5 jd (JD)
↔ Julian Day to Excel Serial Date

How to Convert excel to jd

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

The Formula

jd = excel × 1

Key Fact

1 excel serial date = 1 jd

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

excel to jd Table

exceljd
0 Excel2.415e6 JD
86400 Excel2.501e6 JD
604800 Excel3.02e6 JD
1765550511 Excel1.768e9 JD

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