How many days left in 2027?

There are

501

days left in 2027

until December 31, 2027

Starting today, Monday, August 17, 2026: 501 days — 71 full weeks, or 359 working days — left in 2027. 2027 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, 2027, weekends included — that's 501 days. The working-day count (359) 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 2027?

There are 501 days left in 2027, counting from today to December 31, 2027.

How many working days are left in 2027?

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

How many weeks are left in 2027?

There are 71 full weeks (501 days) left in 2027.

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)).