How to convert Julian Date to regular excel date

Hey fellas,

i've been trying to convert a seven digit Julian Date to regular excel date. Actually i was able to do it, although i checked other ways to do it and i was ended up working with to formulas which gave me two different results. Now i'm not sure which result is right . Can anyone help? Thanx in advance.

Julian Date Digits = 2012200

First Formula used =Date(int(A1/1000),1,mod(A1,1000)) Result date obtained = Jul-18-12 (found this firs formula here on this forum)

Second Formula used =DATE(IF(0+(LEFT(A1,2))<30,2000,1900)+LEFT(A1,2),1,RIGHT(A1,3)) Result date obtained = Jul-18-20

Also Fellas according to PcMag the Julian date for December 11, 1942 is 2430705, i tried this julian date "2430705", i tried in my first formula and i got Result date Dec-6-31
and on my second formula i got Dec-5-25

So now i really don't know which is which, please help Fellas.

Try this:

=DATE(LEFT(A1,4),1,RIGHT(A1,3))

Hey Judgeh59,

according to the julian date you provided "113169" the fist formula works. =Date(int(A1/1000),1,mod(A1,1000))

Thanx a lot, very much apreciated;

Teethless mama ,

according to your formula "=DATE(LEFT(A1,4),1,RIGHT(A1,3))" the year comes out messed up. but thanx anyways

Hey Ernest, yes it did fix the issue, thanx .
teethless mama i had tried you formula with judgeh59's julian version 113169... and it didnt work , but just like judgeh said when i try it with my version of julian date which is the one with seven digits, it works just fine. so thank u very much . it all works .