MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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)