Julian Date Conversion

Joined
Jun 13, 2018
Messages
1
Reaction score
0
Hi everybody,
I know there was a thread dealing with JD conversion.... But none of the formulas (7) provided gave me the right answer to convert from JD 2458282 to 6/12/2018. To confirm that that the conversion is correct, I went to: http://aa.usno.navy.mil/data/docs/JulianDate.php#juld .... But I needed the correct formula in Excel to convert 10,000s records.

Wish someone can help
 

macropod

Microsoft MVP
Joined
Mar 2, 2012
Messages
580
Reaction score
50
The conversion in Excel is as simple as:
=A1-2415019
with the result formatted as a date.
 
Top