How many days left in 2029?

There are

1,213

days left in 2029

until December 31, 2029

Starting today, Saturday, September 5, 2026: 1213 days — 173 full weeks, or 866 working days — left in 2029. 2029 has 365 days. This page recalculates on every visit — bookmark or share the link below.

Copy Link

How it's calculated: count the calendar days from today to December 31, 2029, weekends included — that's 1213 days. The working-day count (866) skips Saturdays and Sundays but does not subtract public holidays.

In Excel or Google Sheets:=DATE(YEAR(TODAY()), 12, 31) - TODAY()or, counting working days only:=NETWORKDAYS(TODAY(), DATE(YEAR(TODAY()), 12, 31))

How much of the year is over?

What day of the week is any date?

Days until Christmas?

Days until any date?

How many days are left in 2029?

There are 1213 days left in 2029, counting from today to December 31, 2029.

How many working days are left in 2029?

There are 866 working days (Monday through Friday, public holidays not subtracted) left in 2029.

How many weeks are left in 2029?

There are 173 full weeks (1213 days) left in 2029.

What is the Excel formula for days remaining in the year?

=DATE(YEAR(TODAY()), 12, 31) - TODAY() — works in Excel and Google Sheets. For working days only, use =NETWORKDAYS(TODAY(), DATE(YEAR(TODAY()), 12, 31)).