This tool converts Julian-style dates in your selection into standard Excel date values.
Julian dates are often used in data exports from legacy systems and represent dates as a combination of the year and the day of the year:
This date format is commonly used in logistics, finance, mainframe systems, and software like JD Edwards and AS/400.
After conversion, the dates become regular Excel date values, which you can use in formulas, formatting, or sorting.
Note:
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional search terms to help you find this tool:
julian date format, convert yyddd to date, convert yyyyddd, cyyddd conversion, jd edwards date format, as400 julian date, day of year format, ordinal date, mainframe date conversion, business julian date, legacy system date format, julian to excel date, convert julian number
Tip:Alt+P for the previous tool.
Tip: Alt+N for the next tool.
Start saving time in Excel with practical tools you can use right away.
No sign-up required.
Free 90-day trial