Date Utilities by FailFlow
Weeks UntilDays UntilDate DurationTools

How many weeks left in 2027?

There are
63
weeks left in 2027
until December 31, 2027
Starting today, Wednesday, October 14, 2026: 63 weeks, or 443 days (31 fortnights), left in 2027. 2027 has 52 ISO weeks. This page recalculates on every visit — bookmark or share the link below.

This countdown stays on 2027. For a countdown that follows the current year, use weeks left in the year.

Copy Link
How it's calculated: count the days from today to December 31, 2027 (443 days), divide by 7, and round down — 443 ÷ 7 = 63 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:=MAX(0, INT((DATE(2027, 12, 31) - TODAY()) / 7))or, rounding to the nearest week instead of down:=MAX(0, ROUND((DATE(2027, 12, 31) - TODAY()) / 7, 0))Both formulas return zero after the year ends.
Weeks left in 2026?
Weeks left in 2028?
Days left in 2027?
Months left in 2027?
How much of the year is over?
What week is it?
Counting in fortnights?
Weeks until Christmas?
Weeks until Summer?
Weeks until any date?

How many weeks are left in 2027?

There are 63 full weeks (443 days) left in 2027, counting from today to December 31, 2027.

How many days are left in 2027?

There are 443 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: 443 days ÷ 7 = 63 full weeks. Subtracting week numbers also works but can drift in 53-week ISO years.

What is the Excel formula for weeks remaining in 2027?

=MAX(0, INT((DATE(2027, 12, 31) - TODAY()) / 7)) — or use =MAX(0, ROUND((DATE(2027, 12, 31) - TODAY()) / 7, 0)) to round to the nearest week. Both return zero after the year ends. Works in Excel and Google Sheets.

How many fortnights are left in 2027?

There are 31 fortnights (two-week periods) left in 2027.

How Many Weeks Left in 2027?