What Day of the Year Is It?

Are you trying to figure out what the current day number is?

icon for a calendar with one day highlighted red icon for a calendar with one day highlighted red

Today Is:

Day 14

Week 2

Today is day 14 of 365 days in 2025. This is calculated from today's date (January 14, 2025) using the ISO-8601 date format.

How Many Days Are Left in the Year?

There are 351 days left in 2025, in case you want to start your countdown to New Year's.

What Week Number Is It?

We are currently in week 2 of 52 weeks in 2025. You can also use our week of the year page to check the current week number.

What Is a Day Number?

A day number is part of an ordinal date, a date format that consists of the year and the day number of the year, ranging from 1 to 365 (366 on leap years). The day of the year (DOY) is referred to as the ordinal day number and is part of the ISO-8601 international date standard.[1]

2025 Day of the Year Calendar

The DOY calendar below shows the day number of the year for each day of 2025. The current day of the year is highlighted in yellow.

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

To print a monthly or yearly calendar and see holidays, try our online calendar.

How To Calculate the Day of the Year Using Google Sheets or Microsoft Excel

You can also calculate the current day number in 2025 using spreadsheet software such as Google Sheets or Microsoft Excel. There are a few different DOY formulas you can use for this, depending on whether you want the day number of today or a specific date.

For the Current Date

If you want to find the day number for the current date, then use the following function:

=TODAY() - DATE(YEAR(TODAY()), 1, 0)

For instance, if the current date is October 30th, then the formula might look like this, with the result being day number 303 as seen in the graphic below:

Graphic showing the formula for Google Sheets or Microsoft Excel to calculate the day number for the current date.

For Any Date

If you want to find the day number for a specific date listed in another cell, for instance, cell A3, then you can use the following function:

=A3 - DATE(YEAR(A3), 1, 0)

For example, if there is a date value in cell A3, then the formula might look like this, which calculates the day number of June 15th, 2023 as day number 166:

Graphic showing the formula for Google Sheets or Microsoft Excel to calculate the day number any date.

If the date is listed in a cell other than A3, simply replace A3 with the cell containing the specified date.

You might also be interested in our day of the week calculator to find the day of the week for any date.

References

  1. International Organization for Standardization, ISO 8601 Date and Time Format, https://www.iso.org/iso-8601-date-and-time-format.html