Julian Date
Posted by Mike on September 13, 2001 8:03 AM
I am trying to figure out how to change a Julian date to a mm/dd/yy format?
Ex: 2001256 = 9/13/01
Posted by Mark W. on September 13, 2001 8:10 AM
With your Julian date in cell A1...
=DATE(LEFT(A1,4),1,1)+RIGHT(A1,3)-1
or
=DATE(LEFT(A1,4)-1,12,31)+RIGHT(A1,3)
