What is YYDDD?
YYDDD uses the last two digits of the year followed by the day number within the year.
Example: the 152nd day of 2025 becomes 25152.
Julian Date Converter
Julian Date Converter
Convert Gregorian, YYDDD and CYYDDD dates instantly.
Built for quick checks, spreadsheets, data work and operational systems.
Converter
Results
YYDDD
—
CYYDDD
—
YYDDD = 2-digit year + day of year •
CYYDDD = century + 2-digit year + day of year
What is CYYDDD?
CYYDDD adds a century digit before the year and day number.
Example: 125152 means century 1, year 25, day 152.
Fast by design
JulianDate.net is built as a lightweight utility: fast loading, no account required, and focused on getting the right date value quickly.
Bulk Converter
Paste multiple dates or Julian values, convert them in one batch, and copy the results straight back into Excel, ERP sheets or data tools.
One value per line. Empty lines are ignored.
Results are returned one per line, ready to paste into spreadsheets.
Ready
Excel Formulas
Copy these formulas into Excel to convert dates directly in your own sheets.
The examples assume your source value is in cell A2.
Gregorian → YYDDD
Convert a normal Excel date in A2 to a 5-digit YYDDD value.
=TEXT(MOD(YEAR(A2),100),"00")&TEXT(A2-DATE(YEAR(A2),1,0),"000")
Example result: 26152
Gregorian → CYYDDD
Convert a normal Excel date in A2 to a 6-digit CYYDDD value.
=INT((YEAR(A2)-1900)/100)&TEXT(MOD(YEAR(A2),100),"00")&TEXT(A2-DATE(YEAR(A2),1,0),"000")
Example result: 126152
YYDDD → Gregorian
Convert a 5-digit YYDDD value in A2 back to an Excel date.
=DATE(2000+VALUE(LEFT(A2,2)),1,VALUE(RIGHT(A2,3)))
Format the result as Date
CYYDDD → Gregorian
Convert a 6-digit CYYDDD value in A2 back to an Excel date.
=DATE(1900+(VALUE(LEFT(A2,1))*100)+VALUE(MID(A2,2,2)),1,VALUE(RIGHT(A2,3)))
Format the result as Date