Converting Julian Dates to regular dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet (inherited) that uses Julian dates in one field - I need
to display the same date in another field in conventional date format. Is
there a formula that will accomplish this? Thanks for your help!
 
One way:

A1: <julian date>
B1: =A1 + 2415018.5         (Windows default 1900 date system)

Format as General and adjust for your time zone. Julian dates are based
on noon, UT (GMT

If you're using the 1904 date system, add 2416480.5 instead.

Ref: http://aa.usno.navy.mil/data/docs/JulianDate.html
 
You must log in or register to reply here.

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

Convert a julian gregorian date code into a regular date 3
Moon phases and julian dates 0
to convert a julian date back to regular date 1
how to convert julian date to regular calendar date 5
JULIAN DATES? 8
How do I convert from a julian date to a standard date mm/dd/yyy 3
how to convert julian date to general date 1
How do I convert Julian date to fiscal date 1

Back
Top