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