How many weeks left in the year?
There are
6
full weeks left in 2026
until December 31, 2026
Starting today, Monday, November 16, 2026: 6 weeks (45 days) left in 2026. That's 6 full Monday-to-Sunday weeks between now and December 31, 2026. This page recalculates on every visit. Bookmark or share the link below.
How it's calculated: the big number counts full 7-day weeks remaining, Monday to Sunday. A partial week at the start or end isn't counted as a full one. For a day-precise answer, 45 days remain until December 31, 2026.
In Excel or Google Sheets:
=INT((DATE(YEAR(TODAY()),12,31) - TODAY()) / 7)as a precise fraction of weeks:
=(DATE(YEAR(TODAY()),12,31) - TODAY()) / 7How many weeks are left in 2026?There are 6 weeks left in 2026. That's 6 full Monday-to-Sunday weeks between now and December 31, 2026.
How many months are left in 2026?There are 1 month left in 2026.
Does the weeks-left count include the current week?No, the count is full weeks that have not started yet. The remaining time in the current week is on top of the 6 full weeks.
What is the Excel formula for weeks remaining in the year?=INT((DATE(YEAR(TODAY()),12,31) - TODAY()) / 7), or =(DATE(YEAR(TODAY()),12,31) - TODAY()) / 7.