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