How Many Weeks Are Left in 2026?

Loading today's date…

How do you calculate how many weeks are left?

To find the number of weeks remaining in the current year with the Weeks Left in the Year tool, follow these simple steps.

1. Get the current week number.
2. Determine the total number of weeks in the current year.
3. Subtract the current week number from the total number of weeks.
4. The result is the number of weeks remaining.

How to calculate the remaining weeks using Excel

To calculate the number of weeks left in the year from today, enter the following formula in Excel or Google Sheets:

=INT((DATE(YEAR(TODAY()), 12, 31) - TODAY()) / 7)

Alternatively you can use the formula that rounds the number.

=ROUND((DATE(YEAR(TODAY()), 12, 31) - TODAY()) / 7, 0)