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+B2DATE(YEAR(B2),"01","01")+1
This will convert B2 back to 102324
Your spreadsheet will look like this.
Back to Mini Solve Products and other Tips

