Dayswise

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()) / 7
Months left in 2026?Days left in 2026?Weeks left in 2027?How much of the year is over?Weeks until any date?45 days from today?

How 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.