Date Utilities by FailFlow
Weeks UntilDays UntilDate DurationTools

How many weeks left in 2029?

There are
166
weeks left in 2029
until December 31, 2029
Starting today, Tuesday, October 20, 2026: 166 weeks, or 1168 days (83 fortnights), left in 2029. 2029 has 52 ISO weeks. This page recalculates on every visit — bookmark or share the link below.

This countdown stays on 2029. 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, 2029 (1168 days), divide by 7, and round down — 1168 ÷ 7 = 166 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(2029, 12, 31) - TODAY()) / 7))or, rounding to the nearest week instead of down:=MAX(0, ROUND((DATE(2029, 12, 31) - TODAY()) / 7, 0))Both formulas return zero after the year ends.
Weeks left in 2026?
Weeks left in 2027?
Weeks left in 2028?
Days left in 2029?
Months left in 2029?
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 2029?

There are 166 full weeks (1168 days) left in 2029, counting from today to December 31, 2029.

How many days are left in 2029?

There are 1168 days left in 2029.

How do you calculate the weeks left in 2029?

Count the days from today to December 31, 2029, then divide by 7 and round down: 1168 days ÷ 7 = 166 full weeks. Subtracting week numbers also works but can drift in 53-week ISO years.

What is the Excel formula for weeks remaining in 2029?

=MAX(0, INT((DATE(2029, 12, 31) - TODAY()) / 7)) — or use =MAX(0, ROUND((DATE(2029, 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 2029?

There are 83 fortnights (two-week periods) left in 2029.

How Many Weeks Left in 2029?