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

[Rosemary]

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

 

[pdberger]

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

 

[David Biddulph]

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

There are numerous other hits that you could try.

 

[Teethless mama]

Try this:

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