The strings should convert to the following I believe if I am converting them correctly.
110356 12/22/2010
110351 12/17/2010
110364 12/30/2010
111003 1/3/2011
I have this formula to work with which seems to be working but I can't help wondering if this is the best way to work with these types of Julian Dates especially when there are as many as I have to work with, and it's a lot.
=DATE(YEAR("01/01/"&TEXT(1900+INT(E22/1000),0)),MONTH("01/01/"&TEXT(1900+INT(E22/1000),0)),DAY("01/01/"&TEXT(1900+INT(E22/1000),0)))+MOD(E22,1000)-1
Any suggestions on another method to work with this?
Bookmarks