Starting today, Sunday, April 12, 2026, we have 37 weeks or 263 days remaining. We are currently in week number 16 of the year.
To calculate how many weeks are left in the current year, you can use the following steps:
1. Get the current week number.
Today, Sunday, April 12, 2026, we are in week 16 of the year.
2. Determine the total number of weeks in the current year.
In 2026, there are 52 weeks.
3. Subtract the current week number from the total number of weeks.
52 - 16 = 37 weeks.
4. The result is the number of weeks remaining.
37 weeks left in 2026.
To compute the number of weeks remaining in the year from the current date in Excel or Google Sheets, use the following function in a cell:
=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)