How to Convert JD to Excel
To convert jd to excel, multiply the value by 1.
The Formula
Excel = JD × 1
Key Fact
1 julian day = 1 excel
Tip: To convert excel back to jd, divide by 1.
Julian Day to Excel Serial Date
Convert jd (JD) to excel (Excel) with formulas, examples, and conversion tables.
JD
Excel
1 JD = -2415017.5 Excel
Full precision:-2415017.5 Excel
Step-by-Step Solution
To convert 1 jd to excel, we multiply by 1 because one julian day equals exactly 1 excel.
1 julian day = 1 excel
Since each julian day contains 1 excel, we multiply our value by this factor:
1 × 1 = -2415017.5 excel
So 1 jd = -2415017.5 excel.
Quick check: -2415017.5 ÷ 1 = 1 jd
Example Conversions
Example 1: 1 JD = -2415017.5 Excel
1 × 1 = -2415017.5
1 × 1 = -2415017.5
Example 2: 5 JD = -2415013.5 Excel
5 × 1 = -2415013.5
5 × 1 = -2415013.5
Example 3: 10 JD = -2415008.5 Excel
10 × 1 = -2415008.5
10 × 1 = -2415008.5
JD to Excel Table
| JD | Excel |
|---|---|
| 0 JD | -2415018.5 Excel |
| 86400 JD | -2328618.5 Excel |
| 604800 JD | -1810218.5 Excel |
| 1765163406 JD | 1762748387.34 Excel |
1 Julian Day in Other Units
| Unit | 1 JD = |
|---|---|
| Julian Day to Unix Timestamp | -2.1087e+11 Unix |
| Julian Day to ISO 8601 | -2.1087e+11 ISO |
| Julian Day to Modified Julian Day | -2399999.5 MJD |
| Julian Day to Excel Serial Date | -2415017.5 Excel |