scott_parker
Reputable Poster
RE: Converting JDE Julian Dates into something more readable .
I played around with this some and had to change it to get it to work for me.
=DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+MID(A1,3,1),1,RIGHT(A1,3))
I don't know why the e-mail converted your "Less than sign" to $lt;.
Also, I am curious on why you used that 2nd LEFT(A1,2) instead of a MID(A1,3,1).
Scott Parker
I played around with this some and had to change it to get it to work for me.
=DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+MID(A1,3,1),1,RIGHT(A1,3))
I don't know why the e-mail converted your "Less than sign" to $lt;.
Also, I am curious on why you used that 2nd LEFT(A1,2) instead of a MID(A1,3,1).
Scott Parker