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