This countdown follows the current year. For a link that stays on 2026, use weeks left in 2026.
=MAX(0, INT((DATE(YEAR(TODAY()), 12, 31) - TODAY()) / 7))or, rounding to the nearest week instead of down:=MAX(0, ROUND((DATE(YEAR(TODAY()), 12, 31) - TODAY()) / 7, 0))Both formulas return zero after the year ends.There are 11 full weeks (78 days) left in 2026, counting from today to December 31, 2026.
There are 78 days left in 2026.
We are currently in ISO week 42 of 53 in 2026.
Count the days from today to December 31, 2026, then divide by 7 and round down: 78 days ÷ 7 = 11 full weeks. Subtracting week numbers also works but can drift in 53-week ISO years — 2026 is one.
=MAX(0, INT((DATE(YEAR(TODAY()), 12, 31) - TODAY()) / 7)) — or use =MAX(0, ROUND((DATE(YEAR(TODAY()), 12, 31) - TODAY()) / 7, 0)) to round to the nearest week. Both return zero after the year ends. Works in Excel and Google Sheets.
There are 5 fortnights (two-week periods) left in 2026.