122
Starting today, Sunday, August 30, 2026: 122 weeks, or 854 days (61 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 (854 days), divide by 7, and round down — 854 ÷ 7 = 122 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 122 full weeks (854 days) left in 2028, counting from today to December 31, 2028.
How many days are left in 2028?
There are 854 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: 854 days ÷ 7 = 122 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 61 fortnights (two-week periods) left in 2028.