User:Support8888

EXCEL FORMULAS

Convert JDE Julian date to Gregorian date (A1 is the cell to calculate): =DATE(LEFT(A1,3),1,RIGHT(A1,3))