Date to Week Number Converter
Convert a date to its week number, week-based year, weekday, week start and end dates, and planning metadata.
2023-10-16 falls in ISO Week 42 of 2023 (2023-W42-1), from 2023-10-16 through 2023-10-22.
- Date
- 2023-10-16
- Week system
- ISO
- ISO week date
- 2023-W42-1
- Week-based year
- 2023
- Week number
- 42
- Week starts
- 2023-10-16
- Week ends
- 2023-10-22
- Day of year
- 289
- Quarter
- Q4
- Weeks remaining
- 10
- Excel formula
- =ISOWEEKNUM(DATE(2023,10,16))
Public holidays this week
Country: Holiday country unavailable
Holiday country could not be inferred from this time zone yet.
Copy this result
Copy the calculated week result or a shareable URL with this date, time zone, and week system.
Continue planning this ISO week
2023-W42 runs from 2023-10-16 to 2023-10-22. Open all seven dates, download a calendar event, or use the ISO week-year in your spreadsheet.
ISO date-to-week examples around New Year
The ISO week-year can differ from the calendar year. January 1–3, 2027 belong to 2026-W53; 2027-W01 starts on Monday, January 4. These fixed examples use UTC and ISO weeks.
| Calendar date | ISO week-year and week | Monday–Sunday date range |
|---|---|---|
| Try 2027-01-01 | 2026-W53 | 2026-12-28 to 2027-01-03 |
| Try 2027-01-04 | 2027-W01 | 2027-01-04 to 2027-01-10 |