Today is day 53 of 365 days in the year 2025. This is calculated from February 22nd, 2025 using the ISO-8601 date format. This means there are 312 days left in the year. We are currently in week 7 of 52.
A day number is simply the day’s position within the year. It’s part of the ordinal date, a format consisting of the year and the day number, ranging from 1 to 365 (or 366 in leap years). This is also known as the day of the year (DOY) and follows the ISO-8601 international date standard.
The DOY calendar below displays the day number for each day of 2025.
| JANUARY |
|---|
| Sun |
| 11 |
| 55 |
| 1212 |
| 1919 |
| 2626 |
| FEBRUARY |
|---|
| Sun |
| 132 |
| 233 |
| 940 |
| 1647 |
| 2354 |
You can easily calculate the current day number using spreadsheet software like Google Sheets or Microsoft Excel. There are different formulas depending on whether you need today’s day number or that of a specific date.
To find the day number for the current date, use this formula:
=TODAY() - DATE(YEAR(TODAY()), 1, 0)
To calculate the day number for any date in a specific cell (e.g., cell A3), use this formula:
=A3 - DATE(YEAR(A3), 1, 0)
If the date is in a cell other than A3, replace “A3” with the correct cell reference. This formula calculates the difference between the target date and the first day of that year, giving you the day number.
