English

SYOJIN-Tools › Julian Date Converter

Julian Date Converter: Read Any Julian Date Code

Pick a date to see all its julian date codes, or type a code (like 26319 or 2461359.5) to get the calendar date. Today is filled in.

Date to julian date

Julian date to date

Next tool

Advertisement

On this page
  1. Two different "julian dates"
  2. Julian date codes on food, eggs and products
  3. Excel formulas
  4. Day of year chart
  5. Summary

Two different "julian dates"

In business, a julian date usually means an ordinal date: the year and the day of the year, like 26319 for the 319th day of 2026 (November 15). It has nothing to do with the Julian calendar. In astronomy, the Julian Day (JD) is a running count of days since 4713 BC, used to compare observations: 2461359.5 is November 15, 2026 at 00:00 UTC. The Modified Julian Day (MJD) is JD minus 2,400,000.5.

Julian date codes on food, eggs and products

WhereUsual formatExample for Nov 15, 2026
Egg cartons (US pack date)3 digit day of year319
Canned food, beer, snacksOften 4 or 5 digits inside a longer lot code6319 or 26319
Manufacturing, military supply5 digit YYDDD (sometimes YDDD)26319
JD Edwards / Oracle6 digit CYYDDD126319
Mainframes, ISO 8601 ordinal dates7 digit YYYYDDD (2026-319)2026319

Lot codes often add plant or line numbers before or after the date; find the digits that change daily. A code shows when a product was packed, not always its best-before date.

Advertisement

Excel formulas

With a date in A1 (or a code in A1 as text):

You wantFormula
Date to 5 digit YYDDD=TEXT(A1,"yy")&TEXT(A1-DATE(YEAR(A1),1,0),"000")
Date to 7 digit YYYYDDD=YEAR(A1)&TEXT(A1-DATE(YEAR(A1),1,0),"000")
5 digit YYDDD to date=DATE(IF(LEFT(A1,2)*1<50,2000,1900)+LEFT(A1,2),1,RIGHT(A1,3))
JDE CYYDDD to date=DATE(1900+LEFT(A1,LEN(A1)-3),1,RIGHT(A1,3))
Date to Julian Day (00:00 UTC)=A1+2415018.5

Format the result cell as a date where the formula returns a date.

Day of year chart

DateDay number (normal year)Day number (leap year)
Jan 1001001
Feb 1032032
Mar 1060061
Apr 1091092
May 1121122
Jun 1152153
Jul 1182183
Aug 1213214
Sep 1244245
Oct 1274275
Nov 1305306
Dec 1335336

Leap years (2024, 2028) have 366 days, so from March 1 every day number is one higher.

Summary

Pick a date to get its 3, 4, 5 and 7 digit julian codes, the JDE format and the astronomical Julian Day, or type a code to get the calendar date back; the Excel formulas do the same in a spreadsheet. Converting Japanese dates too? Use the Japanese era converter.

Advertisement