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

  2. thephoenician

    macropod Microsoft MVP

    Joined:
    Mar 2, 2012
    Messages:
    394
    Likes Received:
    35
    The conversion in Excel is as simple as:
    =A1-2415019
    with the result formatted as a date.
     
    macropod, Oct 1, 2018
    #2
    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.