How many weeks left in the year?
There are
53
full weeks left in 2027
2027 hasn't started yet
That's every full week of 2027, start to finish. This page recalculates on every visit. Bookmark or share the link below.
How it's calculated: the big number counts full 7-day weeks remaining, Monday to Sunday. A partial week at the start or end isn't counted as a full one. For a day-precise answer, 365 days remain until December 31, 2027.
In Excel or Google Sheets:
=INT((DATE(YEAR(TODAY()),12,31) - TODAY()) / 7)as a precise fraction of weeks:
=(DATE(YEAR(TODAY()),12,31) - TODAY()) / 7How many weeks are left in 2027?There are 53 weeks left in 2027. That's every full week of 2027, start to finish.
How many months are left in 2027?There are 12 months left in 2027.
Does the weeks-left count include the current week?No, the count is full weeks that have not started yet. The remaining time in the current week is on top of the 53 full weeks.
What is the Excel formula for weeks remaining in the year?=INT((DATE(YEAR(TODAY()),12,31) - TODAY()) / 7), or =(DATE(YEAR(TODAY()),12,31) - TODAY()) / 7.