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

In article ,
CDTucson wrote:

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!

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

On Wed, 6 Jun 2007 19:32:01 -0700, CDTucson
wrote:

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!