69
Starting today, Sunday, August 30, 2026: 69 weeks, or 488 days (34 fortnights), left in 2027. 2027 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, 2027 (488 days), divide by 7, and round down — 488 ÷ 7 = 69 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 2027?
There are 69 full weeks (488 days) left in 2027, counting from today to December 31, 2027.
How many days are left in 2027?
There are 488 days left in 2027.
How do you calculate the weeks left in 2027?
Count the days from today to December 31, 2027, then divide by 7 and round down: 488 days ÷ 7 = 69 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 2027?
There are 34 fortnights (two-week periods) left in 2027.