How do I convert from a julian date to a standard date mm/dd/yyy

Thread view:

Thread rating:

Rosemary - 13 Mar 2008 15:50 GMT

can someone give me the formula for converting from a julian date to a
standard mm/dd/yy year formt

pdberger - 13 Mar 2008 15:58 GMT

Rosemary --

Here's something that might work:

A B
1 35 =DATE(YEAR(TODAY()),1,1)+A1-1

returns the answer of 2/4/2008.

HTH

> can someone give me the formula for converting from a julian date to a
> standard mm/dd/yy year formt

David Biddulph - 13 Mar 2008 16:06 GMT

The first hit I found with Google was
http://www.cpearson.com/excel/jdates.htm

There are numerous other hits that you could try.

Signature

David Biddulph

> can someone give me the formula for converting from a julian date to a
> standard mm/dd/yy year formt

Teethless mama - 13 Mar 2008 16:35 GMT

Try this:

=DATE(YEAR(TODAY()),1,A1)

> can someone give me the formula for converting from a julian date to a
> standard mm/dd/yy year formt