How to Convert 5-Digit Julian Dates to Regular Dates in Excel
The Julian date format is a five digit number broken into two parts: a two-digit representation of the year followed by a three-digit representation of the day of the year. For example, January 1st, 1999 is 99001 in Julian format. Many older applications store dates like this, and while Excel doesn't recognize this date format by default, that can be solved with a formula.
Start Excel and start a new worksheet if one does not open by default.
Insert the following equation into the desired cell:
Type the Julian date into the cell or reference the cell and/or date to get the desired result.
Eric Wilborn has been writing since 2000, covering topics from computers to phones to cars for various websites. He studied computer science and photography at Olivet Nazarene University and has more than 10 years in the information-technology field as well as five years selling and supporting consumer electronics, including mobile phones and cameras.