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 (JD) = -2415017.5 excel (Excel)
Round to:
Step-by-Step Solution
1Write the conversion factor:
1 julian day = 1 excel
2Multiply the value by the conversion factor:
1 × 1 = -2415017.5
3Result:
1 jd (JD) = -2415017.5 excel (Excel)
jd to excel Table
| jd | excel |
|---|---|
| 0 JD | -2.415e6 Excel |
| 86400 JD | -2.329e6 Excel |
| 604800 JD | -1.81e6 Excel |
| 1765550511 JD | 1.763e9 Excel |
1 julian day in Other Units
| Unit | 1 JD = |
|---|---|
| Julian Day to Unix Timestamp | -2.108666736e11 Unix |
| Julian Day to ISO 8601 | -2.108666736e11 ISO |
| Julian Day to Modified Julian Day | -2399999.5 MJD |
| Julian Day to Excel Serial Date | -2415017.5 Excel |