Excel Serial Date to Julian Day

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

Excel
JD
1 Excel = 2415019.5 JD
Full precision:2415019.5 JD
Step-by-Step Solution

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

1 excel serial date = 1 jd

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

1 × 1 = 2415019.5 jd

So 1 excel = 2415019.5 jd.

✓Quick check: 2415019.5 ÷ 1 = 1 excel
↔ 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.

Example Conversions

Example 1: 1 Excel = 2415019.5 JD
1 × 1 = 2415019.5
Example 2: 5 Excel = 2415023.5 JD
5 × 1 = 2415023.5
Example 3: 10 Excel = 2415028.5 JD
10 × 1 = 2415028.5

Excel to JD Table

ExcelJD
0 Excel2415018.5 JD
86400 Excel2501418.5 JD
604800 Excel3019818.5 JD
1765163406 Excel1767578424.36 JD

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