Skip to main content

Find your next tool

Measurement Calculators

Julian Date Converter: YYDDD, Lot Codes & JD

Today’s Julian date code on your device, YYDDD and YYYYDDD lot codes decoded in bulk, a printable day-of-year chart, and Julian Day and MJD with time.

Live calculationWorking shown

Julian date

Convert a Julian date

Today on this device

—

Today’s code appears here once the page has loaded, from your device’s clock and time zone.

What do you want to do?

YYDDD (26045), YYYYDDD (2026045), YDDD (6045), CYYDDD (126045), dates such as 2026-02-14, or lot codes with letters around the number. Up to 500 lines.

Lot codes are usually recent, so 6045 is read as the latest year ending in 6 that is not after this year.

— Calculated on your device once the page has loaded.

Runs in your browser. Codes and dates you type are not sent to a server.

Three things called “Julian”

MeaningWhere you see itExample: 12 November 2026
Ordinal date: year + day of the yearLot and expiry codes on food, drugs and chemicals, US egg cartons, military supply paperwork, mainframes and JD Edwards26316 · 2026316
Julian Day (astronomy)Astronomy, satellite tracking, geodesy and scientific data filesJD 2461356.5 (00:00 UT) · MJD 61356
Julian calendar (Old Style)History, Orthodox church calendars, dates before 1582 (before 1752 in Britain and its colonies)October 30, 2026

Code formats

FormatExample: 12 November 2026Notes
YYDDD26316The most common lot code; the century needs a window.
YYYYDDD2026316No doubt about the year; used in databases and as 2026-316 in ISO 8601.
YDDD6316Repeats every 10 years; read it with the product’s age in mind.
CYYDDD126316JD Edwards: 0 = 1900s, 1 = 2000s.
DDD316Day only, as on US egg cartons; the year comes from context.

Worked examples from the converter

Every result in this table is computed by the same engine as the tool above.

CaseResult
Egg carton pack date 316, packed in 2026November 12, 2026
Pack date 316, packed in 2028 (a leap year)November 11, 2028
Lot code 26045February 14, 2026
4060, made in the 2020sFebruary 29, 2024
4060, made in the 2010sMarch 1, 2014
JD Edwards date 125190July 9, 2025
1 January 1978, 0:00 UT (USNO example)January 1, 1978 · JD 2443509.5
11 August 1877, 7:30 UT (USNO example)August 11, 1877 · JD 2406842.8125
MJD 0November 17, 1858 · 00:00 UT

Julian date calendar for a common year

Day of the year for every date of a 365-day year. In a leap year add 1 from 1 March on: 1 March is 060 in 2026 and 061 in 2024.

DayJanFebMarAprMayJunJulAugSepOctNovDec
1001032060091121152182213244274305335
2002033061092122153183214245275306336
3003034062093123154184215246276307337
4004035063094124155185216247277308338
5005036064095125156186217248278309339
6006037065096126157187218249279310340
7007038066097127158188219250280311341
8008039067098128159189220251281312342
9009040068099129160190221252282313343
10010041069100130161191222253283314344
11011042070101131162192223254284315345
12012043071102132163193224255285316346
13013044072103133164194225256286317347
14014045073104134165195226257287318348
15015046074105135166196227258288319349
16016047075106136167197228259289320350
17017048076107137168198229260290321351
18018049077108138169199230261291322352
19019050078109139170200231262292323353
20020051079110140171201232263293324354
21021052080111141172202233264294325355
22022053081112142173203234265295326356
23023054082113143174204235266296327357
24024055083114144175205236267297328358
25025056084115145176206237268298329359
26026057085116146177207238269299330360
27027058086117147178208239270300331361
28028059087118148179209240271301332362
29029088119149180210241272302333363
30030089120150181211242273303334364
31031090151212243304365

Excel and Google Sheets formulas

TaskFormula
Date in A1 → YYDDD=TEXT(A1,"yy")&TEXT(A1-DATE(YEAR(A1),1,0),"000")
Date in A1 → YYYYDDD=YEAR(A1)*1000+A1-DATE(YEAR(A1),1,0)
YYDDD in A1 → date (00–49 = 2000s)=DATE(IF(INT(A1/1000)<50,2000,1900)+INT(A1/1000),1,MOD(A1,1000))
YYYYDDD in A1 → date=DATE(INT(A1/1000),1,MOD(A1,1000))
Date and time in A1 (UTC) → JD=A1+2415018.5
Date and time in A1 (UTC) → MJD=A1+15018

TEXT format codes follow the language of the spreadsheet (German Excel writes "JJ" where English Excel writes "yy"). The JD and MJD formulas are valid from 1 March 1900.

Sources

Read on 12 November 2026.

How Julian date codes and the Julian Day are worked out

“Julian date” means two different things. On food, drug and chemical lot codes, on US egg cartons and in mainframe files it is an ordinal date: the year followed by the day of the year. 12 November 2026 is day 316 of 2026, so its code is 26316 (YYDDD) or 2026316 (YYYYDDD). In astronomy it is the Julian Day, a running count of days from noon Universal Time on 1 January 4713 BC: 12 November 2026 at 0:00 UT is JD 2461356.5, MJD 61356. The Julian calendar of Julius Caesar is a third meaning; on that calendar the same day is 30 October 2026. This converter shows today’s code from your device’s clock, turns dates into codes and codes back into dates, decodes a whole pasted list, prints a day-of-year chart and works out JD and MJD to the second. Nothing you type leaves your browser.

How to use this calculator

1

To read a code, type or paste it under Code → date: 26316, 2026316, 6316, 126316, or a lot code with letters around the number. Paste a column from a spreadsheet to decode a whole list, then download the table as CSV.

2

To make a code, pick a date under Date → code. The YYDDD, YYYYDDD, YDDD and CYYDDD codes, the day of the year and the days left in the year appear at once.

3

For a two-digit or one-digit year, check the century window and the year range: 4060 is 29 February 2024 if the code is from the 2020s, but 1 March 2014 if it is from the 2010s.

4

For astronomy, open Julian Day and enter the date, the time and its UTC offset to get JD and MJD, or type a JD or MJD to get the calendar date and UT time back.

5

For a wall chart, choose a year under Year chart, then download the day-of-year grid as a PDF or print it.

Where people use it

  • •Reading the pack date on a US egg carton (a three-digit day of the year) or the production code on a can.
  • •Checking lot and expiry codes on medicines, chemicals, adhesives and military supplies against a shelf life.
  • •Converting JD Edwards (CYYDDD) and mainframe (YYDDD) dates in a spreadsheet export.
  • •Getting the Julian Day or MJD of an observation for astronomy, satellite or variable-star work.

Example: one lot code, two possible dates

A tube of adhesive is stamped 4060. Read as YDDD, the 4 is the last digit of the year and 060 is day 60. In 2024, a leap year, day 60 is 29 February; in 2014 it is 1 March. If the tube was made within the last ten years and it is now 2026, the code means 29 February 2024. Written as YYDDD the same day is 24060, and as YYYYDDD 2024060, which leave no doubt about the decade. Its Julian Day Number is 2460370, so at 0:00 UT that day the JD is 2460369.5 and the MJD is 60369.

Century windows, maker codes and other limits

  • •A two-digit year can belong to two centuries. The converter puts 00–49 in the 2000s and 50–99 in the 1900s unless you choose another window; Excel reads two-digit years as 1930–2029, and Python and POSIX as 1969–2068.
  • •A one-digit year (YDDD) repeats every ten years. The converter assumes the code is from the ten years that end with the year you set (this year by default), so a code on something made longer ago is decoded a decade too late.
  • •Makers invent their own codes. Letters, plant numbers and shift digits are often added, and some codes put the day before the year (DDDYY). If a decoded date looks wrong, check the maker’s key.
  • •JD and MJD count Universal Time. Enter local time with its UTC offset, or the result is off by that offset. The difference between UT1, UTC and Terrestrial Time (about a minute) is ignored.
  • •Dates are read in the Gregorian calendar, also before 1582. The US Naval Observatory reads dates up to 4 October 1582 in the Julian calendar, so for older dates compare with the Julian-calendar date shown next to the result.
  • •Years 1 to 9999 only.

Frequently asked questions

What is today’s Julian date?+

It depends on the day, so the converter at the top of this page shows it from your device’s clock. As an example, 12 November 2026 is 26316 in YYDDD and 2026316 in YYYYDDD, and 1 January of any year is day 001.

What is the difference between a Julian date and the Julian Day?+

A Julian date on a package is an ordinal date, the year plus the day of the year (26316). The Julian Day used in astronomy counts days without a break from noon UT on 1 January 4713 BC, so 12 November 2026 at 0:00 UT is JD 2461356.5. The Julian calendar is a third, separate thing: the calendar that the Gregorian reform of 1582 replaced.

How do I read a Julian date code on food?+

Find the three-digit day of the year, usually with one or two year digits in front of it: 26045 is day 45 of 2026, which is 14 February 2026. On US egg cartons with the USDA grade shield, the three-digit pack date is the day the eggs were packed, from 001 for 1 January to 365 for 31 December (366 in a leap year).

How do I convert a Julian date in Excel or Google Sheets?+

For a date in A1, =TEXT(A1,"yy")&TEXT(A1-DATE(YEAR(A1),1,0),"000") gives YYDDD and =YEAR(A1)*1000+A1-DATE(YEAR(A1),1,0) gives YYYYDDD. For a YYYYDDD number in A1, =DATE(INT(A1/1000),1,MOD(A1,1000)) turns it back into a date. The formula table on this page covers YYDDD, JD and MJD too.

Why does the day number change in a leap year?+

Because 29 February is day 60 in a leap year. From 1 March on, every date is one day number higher than in a common year: 1 March is day 60 in 2026 but day 61 in 2024, and 31 December is day 365 or 366.

How is the Julian Day calculated?+

The US Naval Observatory method turns the year, month and day into the Julian Day Number at noon UT with whole-number arithmetic, then adds the time of day as a fraction of a day. The USNO’s own examples: 1 January 1978 at 0:00 UT is JD 2443509.5, and 11 August 1877 at 7:30 UT is JD 2406842.8125. MJD is JD minus 2400000.5.

Semantic next steps

Continue the calculation

These links move to a different input, formula or project stage rather than a keyword variation of this page.

Measurement Calculators

Free publisher widget

Put this calculator on your website

Give readers the live calculator without rebuilding the math. Copy the responsive embed in one click, or customize width, height, border and corner radius before publishing. The branded MAXScanner attribution stays visible.

Preview

Calculator embed HTML

Paste this code into your page. Focus the code box to select it manually.

Keep the result connected to the real job

MAXScanner keeps the formula and assumptions beside the result so you can verify the number before using it in a drawing, estimate, specification, worksheet or document. Where a supplier, manufacturer, drawing or applicable standard owns a requirement, that source remains authoritative.