logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Convert Julian Dates (yyddd, yyyyddd, or cyyddd) to Standard Excel Dates

ASAP Utilities  › Numbers & Dates  ›  16. Convert Julian Dates (yyddd, yyyyddd, or cyyddd) to Standard Excel Dates

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:
  • yyddd (e.g., 24001 = Jan 1, 2024)
          ·  Years are interpreted using Excel's 2029 Rule: values below 30 are treated as 2000-2029, values 30 or higher as 1930-1999.
  • yyyyddd (e.g., 2024001 = Jan 1, 2024)
  • cyyddd (JD Edwards / AS/400 format)
          ·  The first digit is the century (0 = 1900s, 1 = 2000s)
          ·  For example: 010015 = Jan 15, 1910; 124015 = Jan 15, 2024 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:
  • This tool follows Excel's default interpretation of two-digit years using the 2029 Rule: https://learn.microsoft.com/en-us/office/troubleshoot/excel/two-digit-year-numbers
  • Excel date values are based on the Gregorian calendar, starting from January 1, 1900.
  • Although often called "Julian dates" in business and legacy systems, formats like yyddd and yyyyddd are technically known as ordinal dates. This differs from the historical Julian calendar and the astronomical Julian Day Number, which tracks days since 4713 BC and is used by scientists.
  • Only values that follow one of the supported formats are converted. Ensure your data is numeric and structured correctly.

    Screenshots

    Numbers & Dates  ›  16 Convert Julian Dates (yyddd, yyyyddd, or cyyddd) to Standard Excel Dates

    Starting this tool


    Numbers & Dates  ›  16 Convert Julian Dates (yyddd, yyyyddd, or cyyddd) to Standard Excel Dates
    Additional keywords for 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



  • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.