512
Starting today, Thursday, August 6, 2026: 512 days — 73 full weeks, or 366 working days — left in 2027. 2027 has 365 days. This page recalculates on every visit — bookmark or share the link below.
How it's calculated: count the calendar days from today to December 31, 2027, weekends included — that's 512 days. The working-day count (366) 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 many days are left in 2027?
There are 512 days left in 2027, counting from today to December 31, 2027.
How many working days are left in 2027?
There are 366 working days (Monday through Friday, public holidays not subtracted) left in 2027.
How many weeks are left in 2027?
There are 73 full weeks (512 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)).