Julian Date Conversion

T

thephoenician

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

macropod

Microsoft MVP
Joined
Mar 2, 2012
Messages
578
Reaction score
50
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

Similar Threads

Julian Date conversion 9
Convert Julian to Date 1
how do I convert a julian date(JDEdwards) into a calendar date 4
Numerals conversion 2
Access97 conversion issues 10
Convert Date to Julian Date 2
Conversion from Access 97 to 2003 & get a "Conversion Errors" tabl 0
date conversion 1

Top