Julian Date Conversion

Discussion in 'Excel' started by thephoenician, Jun 13, 2018.

  1. thephoenician

    thephoenician

    Joined:
    Jun 13, 2018
    Messages:
    1
    Likes Received:
    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
     
    thephoenician, Jun 13, 2018
    #1
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.