Convert JD Edwards Julian Date to Calendar date in Excel Formula

JD Edwards Julian Date Converter in EXCEL Formulas

Formula to convert a Calendar date to JDE Julian date:
 =CONCAT(YEAR(A1)-1900,RIGHT(CONCAT("000",DAYS(A1,DATE(YEAR(A1),1,1))+1),3))

Formula to convert JD Edwards Julian date to a Calendar date:
=DATE(LEFT(A1,3),1,1)+(RIGHT(A1,3)-1)