119
Starting today, Wednesday, September 16, 2026: 119 weeks, or 837 days (59 fortnights), left in 2028. 2028 has 52 ISO weeks. This page recalculates on every visit — bookmark or share the link below.
How it's calculated: count the days from today to December 31, 2028 (837 days), divide by 7, and round down — 837 ÷ 7 = 119 full weeks. Subtracting the current week number from the year's total also gets close, but drifts in 53-week ISO years, so we count days instead.
In Excel or Google Sheets:=INT((DATE(YEAR(TODAY()), 12, 31) - TODAY()) / 7)or, rounding to the nearest week instead of down:=ROUND((DATE(YEAR(TODAY()), 12, 31) - TODAY()) / 7, 0)
How many weeks are left in 2028?
There are 119 full weeks (837 days) left in 2028, counting from today to December 31, 2028.
How many days are left in 2028?
There are 837 days left in 2028.
How do you calculate the weeks left in 2028?
Count the days from today to December 31, 2028, then divide by 7 and round down: 837 days ÷ 7 = 119 full weeks. Subtracting week numbers also works but can drift in 53-week ISO years.
What is the Excel formula for weeks remaining in the year?
=INT((DATE(YEAR(TODAY()), 12, 31) - TODAY()) / 7) — or use ROUND instead of INT to round to the nearest week. Works in Excel and Google Sheets.
How many fortnights are left in 2028?
There are 59 fortnights (two-week periods) left in 2028.