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 12 full weeks (85 days) left in 2026, counting from today to December 31, 2026.
There are 85 days left in 2026.
We are currently in ISO week 41 of 53 in 2026.
Count the days from today to December 31, 2026, then divide by 7 and round down: 85 days ÷ 7 = 12 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 6 fortnights (two-week periods) left in 2026.