What Day of the Year Is It?

Q: How do I get the day of the year in Excel or Google Sheets?

With a date in cell A1, use =A1-DATE(YEAR(A1),1,0). DATE(year, 1, 0) is December 31 of the previous year, so the difference is the day number. Format the result as a number, not a date.

Today is day 309 of 2026, with 56 days left in the year. The chart below gives the day number (sometimes called the Julian date) of every date in 2026.

Updated November 2026 · By the YearlyCalendar.org team

309

Thursday, November 5, 2026

56 days left · 84.7% of the year done · ISO week 45

Day of the year chart for 2026

Find the month in the top row and the day of the month in the first column.

Day of the year, 2026 (common year, 365 days)
Day	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
1	1	32	60	91	121	152	182	213	244	274	305	335
2	2	33	61	92	122	153	183	214	245	275	306	336
3	3	34	62	93	123	154	184	215	246	276	307	337
4	4	35	63	94	124	155	185	216	247	277	308	338
5	5	36	64	95	125	156	186	217	248	278	309	339
6	6	37	65	96	126	157	187	218	249	279	310	340
7	7	38	66	97	127	158	188	219	250	280	311	341
8	8	39	67	98	128	159	189	220	251	281	312	342
9	9	40	68	99	129	160	190	221	252	282	313	343
10	10	41	69	100	130	161	191	222	253	283	314	344
11	11	42	70	101	131	162	192	223	254	284	315	345
12	12	43	71	102	132	163	193	224	255	285	316	346
13	13	44	72	103	133	164	194	225	256	286	317	347
14	14	45	73	104	134	165	195	226	257	287	318	348
15	15	46	74	105	135	166	196	227	258	288	319	349
16	16	47	75	106	136	167	197	228	259	289	320	350
17	17	48	76	107	137	168	198	229	260	290	321	351
18	18	49	77	108	138	169	199	230	261	291	322	352
19	19	50	78	109	139	170	200	231	262	292	323	353
20	20	51	79	110	140	171	201	232	263	293	324	354
21	21	52	80	111	141	172	202	233	264	294	325	355
22	22	53	81	112	142	173	203	234	265	295	326	356
23	23	54	82	113	143	174	204	235	266	296	327	357
24	24	55	83	114	144	175	205	236	267	297	328	358
25	25	56	84	115	145	176	206	237	268	298	329	359
26	26	57	85	116	146	177	207	238	269	299	330	360
27	27	58	86	117	147	178	208	239	270	300	331	361
28	28	59	87	118	148	179	209	240	271	301	332	362
29	29	—	88	119	149	180	210	241	272	302	333	363
30	30	—	89	120	150	181	211	242	273	303	334	364
31	31	—	90	—	151	—	212	243	—	304	—	365

Leap years: 2026 is a common year. In a leap year such as 2028, February 29 is day 60 and every date from March 1 on is one number higher: March 1 is day 61 and December 31 is day 366.

Milestone day numbers in 2026

Day	Date	Weekday	Note
1	January 1, 2026	Thursday	first day
100	April 10, 2026	Friday	—
150	May 30, 2026	Saturday	—
183	July 2, 2026	Thursday	middle of the year (182 days before and after)
200	July 19, 2026	Sunday	—
250	September 7, 2026	Monday	—
300	October 27, 2026	Tuesday	—
365	December 31, 2026	Thursday	last day

Day numbers in other years

In leap years every date from March 1 on has a day number one higher than in common years.

Year	Days	Leap year	Starts on	March 1	July 4	December 25
2024	366	Yes	Monday	61	186	360
2025	365	No	Wednesday	60	185	359
2026	365	No	Thursday	60	185	359
2027	365	No	Friday	60	185	359
2028	366	Yes	Saturday	61	186	360
2029	365	No	Monday	60	185	359
2030	365	No	Tuesday	60	185	359
2031	365	No	Wednesday	60	185	359
2032	366	Yes	Thursday	61	186	360

Day of the year vs. Julian date

Day of the year (the ordinal date) counts the days of a year from January 1 = day 1. ISO 8601 writes it as year and day number: 2026-309 is November 5, 2026.

“Julian date” is widely used for the same number, especially in the military, manufacturing and food packaging, where a code such as 26309 (YYDDD) means 2026, day 309. That usage is informal.

In astronomy, a Julian Date is a different number: a continuous count of days since noon UTC on January 1, 4713 BC. November 5, 2026 is Julian Day Number 2461350. Neither meaning has anything to do with the Julian calendar of Julius Caesar. Convert dates with the Julian date converter.

Frequently asked questions

How do I work out the day of the year by hand?

Add the days of all earlier months to the day of the month. In a common year the running totals before each month are: Jan 0, Feb 31, Mar 59, Apr 90, May 120, Jun 151, Jul 181, Aug 212, Sep 243, Oct 273, Nov 304, Dec 334. So July 4 is 181 + 4 = day 185. In a leap year, add 1 for any date from March 1 on.

How do I turn a day number back into a date?

Find the last month whose running total is below the number and subtract it. For day 222 of a common year: July ends on day 212, so day 222 is August 10. In a leap year, subtract one more from March on.

How do I get the day of the year in Excel or Google Sheets?

With a date in cell A1, use =A1-DATE(YEAR(A1),1,0). DATE(year, 1, 0) is December 31 of the previous year, so the difference is the day number. Format the result as a number, not a date.

Related calendars and guides

Julian Date ConverterConvert dates to Julian Day Numbers and YYDDD ordinal dates What Week Is It? Current Week NumberToday's ISO 8601 week number and the dates of every week Days Between Dates CalculatorCount days, weeks, months and business days between two dates Leap Years ListThe leap year rule, every leap year 1800–2400 and the next leap day 2026 CalendarFull year with holidays

Day	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
1	1	32	60	91	121	152	182	213	244	274	305	335
2	2	33	61	92	122	153	183	214	245	275	306	336
3	3	34	62	93	123	154	184	215	246	276	307	337
4	4	35	63	94	124	155	185	216	247	277	308	338
5	5	36	64	95	125	156	186	217	248	278	309	339
6	6	37	65	96	126	157	187	218	249	279	310	340
7	7	38	66	97	127	158	188	219	250	280	311	341
8	8	39	67	98	128	159	189	220	251	281	312	342
9	9	40	68	99	129	160	190	221	252	282	313	343
10	10	41	69	100	130	161	191	222	253	283	314	344
11	11	42	70	101	131	162	192	223	254	284	315	345
12	12	43	71	102	132	163	193	224	255	285	316	346
13	13	44	72	103	133	164	194	225	256	286	317	347
14	14	45	73	104	134	165	195	226	257	287	318	348
15	15	46	74	105	135	166	196	227	258	288	319	349
16	16	47	75	106	136	167	197	228	259	289	320	350
17	17	48	76	107	137	168	198	229	260	290	321	351
18	18	49	77	108	138	169	199	230	261	291	322	352
19	19	50	78	109	139	170	200	231	262	292	323	353
20	20	51	79	110	140	171	201	232	263	293	324	354
21	21	52	80	111	141	172	202	233	264	294	325	355
22	22	53	81	112	142	173	203	234	265	295	326	356
23	23	54	82	113	143	174	204	235	266	296	327	357
24	24	55	83	114	144	175	205	236	267	297	328	358
25	25	56	84	115	145	176	206	237	268	298	329	359
26	26	57	85	116	146	177	207	238	269	299	330	360
27	27	58	86	117	147	178	208	239	270	300	331	361
28	28	59	87	118	148	179	209	240	271	301	332	362
29	29	—	88	119	149	180	210	241	272	302	333	363
30	30	—	89	120	150	181	211	242	273	303	334	364
31	31	—	90	—	151	—	212	243	—	304	—	365

Day	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
1	1	32	60	91	121	152	182	213	244	274	305	335
2	2	33	61	92	122	153	183	214	245	275	306	336
3	3	34	62	93	123	154	184	215	246	276	307	337
4	4	35	63	94	124	155	185	216	247	277	308	338
5	5	36	64	95	125	156	186	217	248	278	309	339
6	6	37	65	96	126	157	187	218	249	279	310	340
7	7	38	66	97	127	158	188	219	250	280	311	341
8	8	39	67	98	128	159	189	220	251	281	312	342
9	9	40	68	99	129	160	190	221	252	282	313	343
10	10	41	69	100	130	161	191	222	253	283	314	344
11	11	42	70	101	131	162	192	223	254	284	315	345
12	12	43	71	102	132	163	193	224	255	285	316	346
13	13	44	72	103	133	164	194	225	256	286	317	347
14	14	45	73	104	134	165	195	226	257	287	318	348
15	15	46	74	105	135	166	196	227	258	288	319	349
16	16	47	75	106	136	167	197	228	259	289	320	350
17	17	48	76	107	137	168	198	229	260	290	321	351
18	18	49	77	108	138	169	199	230	261	291	322	352
19	19	50	78	109	139	170	200	231	262	292	323	353
20	20	51	79	110	140	171	201	232	263	293	324	354
21	21	52	80	111	141	172	202	233	264	294	325	355
22	22	53	81	112	142	173	203	234	265	295	326	356
23	23	54	82	113	143	174	204	235	266	296	327	357
24	24	55	83	114	144	175	205	236	267	297	328	358
25	25	56	84	115	145	176	206	237	268	298	329	359
26	26	57	85	116	146	177	207	238	269	299	330	360
27	27	58	86	117	147	178	208	239	270	300	331	361
28	28	59	87	118	148	179	209	240	271	301	332	362
29	29	—	88	119	149	180	210	241	272	302	333	363
30	30	—	89	120	150	181	211	242	273	303	334	364
31	31	—	90	—	151	—	212	243	—	304	—	365

Day	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
1	1	32	60	91	121	152	182	213	244	274	305	335
2	2	33	61	92	122	153	183	214	245	275	306	336
3	3	34	62	93	123	154	184	215	246	276	307	337
4	4	35	63	94	124	155	185	216	247	277	308	338
5	5	36	64	95	125	156	186	217	248	278	309	339
6	6	37	65	96	126	157	187	218	249	279	310	340
7	7	38	66	97	127	158	188	219	250	280	311	341
8	8	39	67	98	128	159	189	220	251	281	312	342
9	9	40	68	99	129	160	190	221	252	282	313	343
10	10	41	69	100	130	161	191	222	253	283	314	344
11	11	42	70	101	131	162	192	223	254	284	315	345
12	12	43	71	102	132	163	193	224	255	285	316	346
13	13	44	72	103	133	164	194	225	256	286	317	347
14	14	45	73	104	134	165	195	226	257	287	318	348
15	15	46	74	105	135	166	196	227	258	288	319	349
16	16	47	75	106	136	167	197	228	259	289	320	350
17	17	48	76	107	137	168	198	229	260	290	321	351
18	18	49	77	108	138	169	199	230	261	291	322	352
19	19	50	78	109	139	170	200	231	262	292	323	353
20	20	51	79	110	140	171	201	232	263	293	324	354
21	21	52	80	111	141	172	202	233	264	294	325	355
22	22	53	81	112	142	173	203	234	265	295	326	356
23	23	54	82	113	143	174	204	235	266	296	327	357
24	24	55	83	114	144	175	205	236	267	297	328	358
25	25	56	84	115	145	176	206	237	268	298	329	359
26	26	57	85	116	146	177	207	238	269	299	330	360
27	27	58	86	117	147	178	208	239	270	300	331	361
28	28	59	87	118	148	179	209	240	271	301	332	362
29	29	—	88	119	149	180	210	241	272	302	333	363
30	30	—	89	120	150	181	211	242	273	303	334	364
31	31	—	90	—	151	—	212	243	—	304	—	365