Julian Date Conversion

CAYMANIAC · Mar 22nd, 2002, 10:15 AM

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

Anne Troy · Mar 22nd, 2002, 10:34 AM

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

Mark W. · Mar 22nd, 2002, 11:46 AM

Quote:

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

[img]/board/images/smiles/icon_smile.gif[/img]

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.

Mar 22nd, 2002, 10:34 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	http://www.cpearson.com/excel/jdates.htm __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 10:15 AM	#1
CAYMANIAC New Member Join Date: Mar 2002 Posts: 4	Is there a formula for converting Julian Dates? My downloaded data is in Julian format.