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...