This countdown stays on 2031. For a countdown that follows the current year, use weeks left in the year.
=MAX(0, INT((DATE(2031, 12, 31) - TODAY()) / 7))or, rounding to the nearest week instead of down:=MAX(0, ROUND((DATE(2031, 12, 31) - TODAY()) / 7, 0))Both formulas return zero after the year ends.There are 271 full weeks (1898 days) left in 2031, counting from today to December 31, 2031.
There are 1898 days left in 2031.
Count the days from today to December 31, 2031, then divide by 7 and round down: 1898 days ÷ 7 = 271 full weeks. Subtracting week numbers also works but can drift in 53-week ISO years.
=MAX(0, INT((DATE(2031, 12, 31) - TODAY()) / 7)) — or use =MAX(0, ROUND((DATE(2031, 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 135 fortnights (two-week periods) left in 2031.