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

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

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

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

"Rosemary" wrote:

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

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

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

There are numerous other hits that you could try.
--
David Biddulph

"Rosemary" wrote in message
...
can someone give me the formula for converting from a julian date to a
standard mm/dd/yy year formt

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

Try this:

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



"Rosemary" wrote:

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