Three things called “Julian”
| Meaning | Where you see it | Example: 12 November 2026 |
|---|---|---|
| Ordinal date: year + day of the year | Lot and expiry codes on food, drugs and chemicals, US egg cartons, military supply paperwork, mainframes and JD Edwards | 26316 · 2026316 |
| Julian Day (astronomy) | Astronomy, satellite tracking, geodesy and scientific data files | JD 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
| Format | Example: 12 November 2026 | Notes |
|---|---|---|
| YYDDD | 26316 | The most common lot code; the century needs a window. |
| YYYYDDD | 2026316 | No doubt about the year; used in databases and as 2026-316 in ISO 8601. |
| YDDD | 6316 | Repeats every 10 years; read it with the product’s age in mind. |
| CYYDDD | 126316 | JD Edwards: 0 = 1900s, 1 = 2000s. |
| DDD | 316 | Day 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.
| Case | Result |
|---|---|
| Egg carton pack date 316, packed in 2026 | November 12, 2026 |
| Pack date 316, packed in 2028 (a leap year) | November 11, 2028 |
| Lot code 26045 | February 14, 2026 |
| 4060, made in the 2020s | February 29, 2024 |
| 4060, made in the 2010s | March 1, 2014 |
| JD Edwards date 125190 | July 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 0 | November 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.
| Day | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 001 | 032 | 060 | 091 | 121 | 152 | 182 | 213 | 244 | 274 | 305 | 335 |
| 2 | 002 | 033 | 061 | 092 | 122 | 153 | 183 | 214 | 245 | 275 | 306 | 336 |
| 3 | 003 | 034 | 062 | 093 | 123 | 154 | 184 | 215 | 246 | 276 | 307 | 337 |
| 4 | 004 | 035 | 063 | 094 | 124 | 155 | 185 | 216 | 247 | 277 | 308 | 338 |
| 5 | 005 | 036 | 064 | 095 | 125 | 156 | 186 | 217 | 248 | 278 | 309 | 339 |
| 6 | 006 | 037 | 065 | 096 | 126 | 157 | 187 | 218 | 249 | 279 | 310 | 340 |
| 7 | 007 | 038 | 066 | 097 | 127 | 158 | 188 | 219 | 250 | 280 | 311 | 341 |
| 8 | 008 | 039 | 067 | 098 | 128 | 159 | 189 | 220 | 251 | 281 | 312 | 342 |
| 9 | 009 | 040 | 068 | 099 | 129 | 160 | 190 | 221 | 252 | 282 | 313 | 343 |
| 10 | 010 | 041 | 069 | 100 | 130 | 161 | 191 | 222 | 253 | 283 | 314 | 344 |
| 11 | 011 | 042 | 070 | 101 | 131 | 162 | 192 | 223 | 254 | 284 | 315 | 345 |
| 12 | 012 | 043 | 071 | 102 | 132 | 163 | 193 | 224 | 255 | 285 | 316 | 346 |
| 13 | 013 | 044 | 072 | 103 | 133 | 164 | 194 | 225 | 256 | 286 | 317 | 347 |
| 14 | 014 | 045 | 073 | 104 | 134 | 165 | 195 | 226 | 257 | 287 | 318 | 348 |
| 15 | 015 | 046 | 074 | 105 | 135 | 166 | 196 | 227 | 258 | 288 | 319 | 349 |
| 16 | 016 | 047 | 075 | 106 | 136 | 167 | 197 | 228 | 259 | 289 | 320 | 350 |
| 17 | 017 | 048 | 076 | 107 | 137 | 168 | 198 | 229 | 260 | 290 | 321 | 351 |
| 18 | 018 | 049 | 077 | 108 | 138 | 169 | 199 | 230 | 261 | 291 | 322 | 352 |
| 19 | 019 | 050 | 078 | 109 | 139 | 170 | 200 | 231 | 262 | 292 | 323 | 353 |
| 20 | 020 | 051 | 079 | 110 | 140 | 171 | 201 | 232 | 263 | 293 | 324 | 354 |
| 21 | 021 | 052 | 080 | 111 | 141 | 172 | 202 | 233 | 264 | 294 | 325 | 355 |
| 22 | 022 | 053 | 081 | 112 | 142 | 173 | 203 | 234 | 265 | 295 | 326 | 356 |
| 23 | 023 | 054 | 082 | 113 | 143 | 174 | 204 | 235 | 266 | 296 | 327 | 357 |
| 24 | 024 | 055 | 083 | 114 | 144 | 175 | 205 | 236 | 267 | 297 | 328 | 358 |
| 25 | 025 | 056 | 084 | 115 | 145 | 176 | 206 | 237 | 268 | 298 | 329 | 359 |
| 26 | 026 | 057 | 085 | 116 | 146 | 177 | 207 | 238 | 269 | 299 | 330 | 360 |
| 27 | 027 | 058 | 086 | 117 | 147 | 178 | 208 | 239 | 270 | 300 | 331 | 361 |
| 28 | 028 | 059 | 087 | 118 | 148 | 179 | 209 | 240 | 271 | 301 | 332 | 362 |
| 29 | 029 | 088 | 119 | 149 | 180 | 210 | 241 | 272 | 302 | 333 | 363 | |
| 30 | 030 | 089 | 120 | 150 | 181 | 211 | 242 | 273 | 303 | 334 | 364 | |
| 31 | 031 | 090 | 151 | 212 | 243 | 304 | 365 |
Excel and Google Sheets formulas
| Task | Formula |
|---|---|
| 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
- US Naval Observatory: Converting Between Julian Dates and Gregorian Calendar Dates
- US Naval Observatory: Julian Date Converter
- Texas DSHS: Food Product Dating (USDA FSIS guidance on egg pack dates)
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
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.
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.
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.
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.
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.
Day of Week Calculator — Weekday, ISO Week & Day of Year
Enter any valid calendar date to find its weekday, ISO week number, day of year and leap-year context without relying on a locale-specific date parser.
Calendar Converter: Hijri, Lunar, Persian, Era
Convert dates between Gregorian and Hijri (Umm al-Qura), Chinese and Korean lunar, Persian, Japanese era, ROC, Thai and Śaka calendars, both ways.
Week Number Calculator
Find the ISO 8601 week number and Monday-to-Sunday date range.
Days Between Dates Calculator
Calculate the exact number of days between two dates.
Leap Year Calculator — Check Any Gregorian Year
Check whether a year is a Gregorian leap year, see why the divisible-by-100 exception matters, and find the previous and next leap years.
Date Calculator — Add, Subtract, Difference & Business Days
Calculate the difference between two dates or add and subtract days, weeks, months and years. Compare calendar days with weekday-only business days, see the result weekday and keep the counting convention visible.
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.
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.