Julian Date Conversion

[CAYMANIAC]

Is there a formula for converting Julian Dates? My downloaded data is in Julian format.

 

[Anne Troy]

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

 

[Mark W.]

On 2002-03-22 09:34, Dreamboat wrote:
http://www.cpearson.com/excel/jdates.htm

/board/images/smiles/icon_smile.gif

The IF function in...

=DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+LEFT(A1,2),1,RIGHT(A1,3))

...isn't necessary as explained in the Excel help topic for "How Microsoft Excel performs date and time calculations". The formula...

=DATE(LEFT(A1,2),1,RIGHT(A1,3))

...is all that's needed.