Tips.gif (2048 bytes)

 

 

 

 

 

Convert Julian to Date in Excel

In Cell A2 place a Julian date, like 102324

in Cell B2 place this formula: (copy it in)

=DATE(YEAR("01/01/"&TEXT(1900+INT(A2/1000),0)),MONTH("01/01/"&TEXT(1900+INT(A2/1000),0)),DAY("01/01/"&TEXT(1900+INT(A2/1000),0)))+MOD(A2,1000)-1

The date 11/20/02 date will appear in cell B2

 

CONVERT DATE TO JULIAN in EXCEL

in cell C2 copy this formula:

=(YEAR(B2)-2000+100)*1000+B2-DATE(YEAR(B2),"01","01")+1

This will convert B2 back to 102324

Your spreadsheet will look like this.

JulExcel.gif (4453 bytes)

Back to Mini Solve Products and other Tips