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
 
Ad

Advertisements

macropod

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top