Converting Julian Dates to regular dates

[CDTucson]

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!

 

[JE McGimpsey]

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

 

[Gord Dibben]

You sure they are Julian dates not just Excel's 5-digit serial numbers?

See Chip Pearson's site for methods of converting.

http://www.cpearson.com/excel/jdates.htm


Gord Dibben MS Excel MVP